News und Artikel von Klaus Aschenbrenner - SQL Server Consulting

... Microsoft Certified Master SQL Server 2008, which is the highest technical certification for SQL Server that is currently available. Because I ... year my popular SQL
Server Performance Tuning & Troubleshooting ... troubleshooting on a SQLMCM level! Based on ... take a real SQL Server workload and execute ... are digging into SQL Server and trying to optimize SQL Server itself based on ...

Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus talks about Bookmark Lookup Deadlocks in SQL Server . You can find the script used during the demonstration here as a download. Thanks for watching! -Santa Claus

Today I have uploaded the 4rd SQL Server Quickie to YouTube. In this episode I'm talking about IAM Pages in SQL Server . You can find here the script I have used during the demonstration as a download. Thanks for watching! -Klaus

... I'm working on Replication – especially with Transactional Replication . The main idea of Transactional Replication is that you have a so-called ... on your Publisher SQL Server database running, that is analyzing ... Transactional Replication through SQL Server Management Studio, you ... isn't available through SQL Server Management Studio – ... transferred over the net work to the ...

Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I'm talking about Extents, and how SQL Server manages those through GAM and SGAM pages. Thanks for reading & watching! -Klaus

... reason a new idea was born: SQL Server Quickie s! The goal of my new SQL Server Quickie s video series is that you can learn about specific advanced SQL Server topics within 5 - 10 minutes by listening to ... hard on the flipchart explaining various SQL Server topics. And by the end we are digging ... very proud to announce my first SQL Server Quickie about Data Pages in SQL Server and ...

... the SP2 for SQL Server 2008 R2. You can download the ... working on a Database Mirroring Test Lab that is based on SQL
Server 2008, I thought it would be ... Upgrade in a Database Mirroring scenario is very straightforward: Disable the ... Witness from your Database Mirroring session: ALTER DATABASE TPC_E SET WITNESS ... write down its net work address, because ... find out the net work address of ...

... first Availability Group with SQL Server 2012. Today I want to show ... scenarios between them. SQL Server Management Studio 2012 provides you here ... existing Replicas, because SQL Server must change the security settings on ... endpoint used for AlwaysOn . When you are adding a ... fine with your AlwaysOn deployment. As you can see from ... are working with AlwaysOn – so stay tuned. Thanks for ...

... blog posting about AlwaysOn you have seen how you can ... Group through the AlwaysOn wizard provided by SQL Server Management Studio 2012. As usual this ... the Availability Group. AlwaysOn provides the same security authentication mechanism ... . When all SQL Server Instances of your Replica are ... logins in each SQL Server Instance. But when ... create a new SQL Server endpoint for Database ...

... your Windows- and SQL Server s for SQL Server 2012 AlwaysOn. In the last 3 ... them with their SQL Server deployments to improve performance and ... with the following net work configuration: Node1 ... enabled for your SQL Server Instances AlwaysOn through the SQL
Server Configuration Manager (which ... restart of the SQL Server instance), you are ... backup through the net work, and finally ...

... scenario occurred, because there were uncommitted transactions from the Activated Stored Procedure, which means that some locks were held forever in SQL Server , which finally blocked the disabling of the queue. See my last blog posting on this phenomenon: http://www.sqlpassion.at/blog/PermaLink,guid,fc4f98af-f42a-4b3d-872e-c31815e6fc02.aspx. So when you have ...

... of your whole SQL Server instance. In this blog posting I ... doing nothing inside SQL Server : --******************************************************************** --* View the currently ... can't just stop SQL Server , you have to do a ... WITH NOWAIT, otherwise SQL Server will not stop ... normal shutdown of SQL Server will not working ... doing anything in SQL Server – it's a very ...

As you might know, I'm running my "SQL Server 2012 Deep Dive Days Workshop" from May 28 – 30 in Central London. You can find out further information about the ... are the exact eligibility requirements to get the free seat: You have to be the FIRST person who registers for my SQL Server 2012 Workshop in London, during the week from May 13 – May 18. You have to use the discount code TWO4ONE ...

As I have announced in my DevWeek and SQLbits sessions, you can find my session materials (slides & samples) here for download: Understanding SQL Server Execution Plans SQL
Server Query Tuning Troubleshooting TempDb Thanks for attending my sessions, it was really awesome speaking for such a large crowd of people, and I'm looking forward to come back very soon to London -Klaus

As I have announced in my DevWeek and SQLbits sessions, you can find my session materials (slides & samples) here for download: Understanding SQL Server Execution Plans SQL Server Query Tuning Troubleshooting TempDb Thanks for attending my sessions, it was really awesome speaking for such a large crowd of people, and I'm looking forward to come back very soon to London J -Klaus

... prepared tons of SQL Server 2012 content for my own SQL Server 2012 Deep Dive Days workshop that ... new features of SQL Server 2012, I have decided to ... to start with SQL Server 2012 AlwaysOn Availability ... hottest features in SQL Server 2012! I want to ... and manage a SQL Server 2012 AlwaysOn High ... you can prepare SQL Server for running an ... others. To minimize net work latency, SQL Server ...