Klaus Aschenbrenner - SQL Server Consulting @CODEKICKER

8

Become an expert in SQL Server Performance Tuning & Troubleshooting!

... 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 ...

13.02.2013 | 55 0

8

SQL Server Quickie #5 – Bookmark Lookup Deadlocks

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

16.12.2012 | 178 0

7

Practical SQL Server Performance Troubleshooting Day

... huge demand of SQL Server Troubleshooting Know How and ... workshop called "Practical SQL Server Performance Troubleshooting Day" (see ... default installation of SQL Server , and run ... various areas of SQL Server to implement different ... have a well-performing SQL Server which can handle ... SQL Server Instance Settings Database ... for SQL Server performance troubleshooting that ...

10.12.2012 | 203 0

10

SQL Server Quickie #4 – IAM Pages

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

16.10.2012 | 97 0

5

Nested Partitioned Views

... to implement their SQL Server database for both Standard and Enterprise ... Partitioned Views in SQL Server . Pros Available on any Edition of SQL Server Each table has its own ... Partitioned Tables in SQL Server . Pros Only ... Enterprise Edition of SQL Server Table-Level Statistics Less ... Standard Edition of SQL Server (where Partitioned Tables ... be done with SQL Server ? Of course, ...

27.09.2012 | 114 0

7

SQL Server Quickie #3 – Allocation Units

Today I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I'm talking about Allocation Units in SQL Server . Thanks for reading & watching -Klausy

18.09.2012 | 117 0

5

My upcoming speaking schedule

... few weeks the conference s eason starts over again. The last ... sessions for upcoming SQL Server conferences , where I'm speaking over the ... Troubleshooting the hardest SQL Server Problems". I'm talking here about things ... sessions about various SQL Server topics: Troubleshooting SQL Server with Extended Events ... following 2 regular conference s essions: Advanced SQL Server ...

21.08.2012 | 112 0

7

Initialize a Transactional Replication from a Database Backup

... 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 ...

05.08.2012 | 113 0

11

SQL Server Quickie #2 - Extents

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

04.08.2012 | 99 0

7

SQL Server Quickies – a new way to learn about SQL Server

... 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 ...

01.08.2012 | 117 0

7

Perform a Rolling Upgrade to SQL Server 2008 R2 SP2 in a Database Mirroring Scenario

... 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 ...

27.07.2012 | 104 0

9

SQL Server 2012 AlwaysOn Availability Groups – Part 4: Adding new Replicas

... 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 ...

26.07.2012 | 155 0

5

SQL Server Performance Tuning & Troubleshooting Workshop

... auch mit dem SQL Server passieren: heute läuft alles rund und morgen hat Ihr SQL Server gröbste Performance Probleme und Sie ... 2012 wieder meinen SQL Server Performance Tuning & ... Basis einer realen SQL Server Workload auf einem ... für Schritt Ihren SQL Server besser in den ... Tools Wait Statistics SQL Server Profiler & Performance ... ist sowohl für SQL Server Entwickler als auch ...

25.07.2012 | 131 0

8

SQL Server 2012 AlwaysOn Availability Groups – Part 3: Setting up AlwaysOn through T-SQL

... 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 ...

23.07.2012 | 143 0

9

SQL Server 2012 AlwaysOn Availability Groups – Part 2

... 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 ...

19.07.2012 | 143 0

4

Service Broker Adventures: Stucked Queue Monitors

... 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 ...

03.07.2012 | 117 0

9

Killing me softly with Service Broker…

... 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 ...

25.06.2012 | 84 0

7

My journey finally ends at the SQLPASS 2012 Summit

... a precon about SQL Server Performance Troubleshooting! I'm really happy to ... session about Advanced SQL Server Troubleshooting (which I'm doing ... my favourite topics – SQL Server Performance Troubleshooting: Practical SQL Server Performance Troubleshooting Learn ... the Windows OS, SQL Server , and your ... presenting two regular conference s essions: ColumnStore Indexes: ...

20.06.2012 | 100 0

7

Chance to win a free seat in my SQL Server 2012 Deep Dive Days workshop in London!

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 ...

13.05.2012 | 168 0

9

Slides & Samples for my SQLConnections sessions

As I have announced announced in my sessions at the SQLConnections conferences in Berchtesgaden/Germany, you can find my session materials (slides & samples) here for download SQL Server Query Tuning SQL Server Memory Management SQL Server 2012 Distributed Replay Thanks for attending my sessions J -Klaus

12.05.2012 | 133 0

7

Slides & Samples for my DevWeek and SQLbits sessions

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

05.04.2012 | 185 0

11

Slides & Samples for my DevWeek and SQLbits sessions

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

01.04.2012 | 150 0

10

Slides & Samples from my SQLSaturday #105 presentation about Advanced SQL Server Troubleshooting

As I have announced in my session last Saturday in Dublin, you can find here the slides & samples for download. Thanks for attending my session and enjoy the download J -Klaus

26.03.2012 | 154 0

9

SQL Server 2012 AlwaysOn Availability Groups – Part 1

... 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 ...

21.03.2012 | 227 0

3

Slides & Samples from my SQLSaturday #115 presentation about ColumnStore Indexes

As I have announced in my ColumnStore presentation last Saturday in Lisbon, you can find here the slides & samples for download. Thanks for attending my session and enjoy the download J. -Klaus

19.03.2012 | 151 0

Klaus Aschenbrenner - SQL Server Consulting

News und Artikel von Klaus Aschenbrenner - SQL Server Consulting