Klaus Aschenbrenner - SQL Server Consulting @CODEKICKER

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 | 16 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 | 18 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 | 61 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 | 51 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 | 57 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 | 55 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 | 59 0

8

Deprecated Features in the SQL Server 2012 Database Engine

... RTM version of SQL Server 2012. If you are an MSDN ... As with every SQL Server release, SQL Server has also marked several features as ... a future version of SQL Server . So if you are starting ... application based on SQL Server 2012, you should check the following ... big changes in SQL Server 2012. Database Mirroring: With the release of SQL Server 2012 and AlwaysOn Availability Groups, ...

09.03.2012 | 98 0

6

New upcoming events across Europe

... 4 new upcoming SQL Server workshops across Europe ... the next months: SQL Server Configuration Day Date/Location ... Day at http://www.SQLpassion.at/events.html. SQL Server 2012 Deep Dive ... London/United Kingdom Agenda SQL Server 2012 Development SQL Server Data Tools T-SQL ... Contained Databases SQL Server Integration Services SQL Server 2012 Administration Extended ...

04.03.2012 | 74 0

9

Statistics Enhancements in SQL Server 2012

... Statistics Enhancements in SQL Server 2012. As you already know SQL Server uses Statistic Objects in a database ... over time, so SQL Server is also able to change ... Auto Update Statistics. SQL Server updates Statistics automatically ... of rows Whenever SQL Server is updating the statistics automatically, SQL Server Profiler reports the ... the other hand, SQL Server is also able to ...

29.02.2012 | 86 0

9

My upcoming speaking engagements

... tons of content about SQL Server 2012 for my upcoming event series ... to speak at various SQL Server conferences across Europe within the next weeks. ... doing my own "SQL Server 2012 Deep Dive Days" with brand ... technical content about SQL Server 2012. March 12 – 14, Munich/Germany: "SQL Server 2012 Deep Dive Days" in Munich/Germany ... – 3 additional conferences , where I have submitted ...

08.02.2012 | 76 0

8

The Blocked Process Report

... a notification from SQL Server when a query has to wait ... was easy, because SQL Server provides you for this functionality the ... scenarios inside your SQL Server installation. The Blocked ... can trace through SQL Server Profiler or SQL ... functionality on the SQL Server instance level through ... a lock until SQL Server raises the Blocked ... During the reading SQL Server tries to acquire ...

01.12.2011 | 74 0

5

Running a TPC-C workload on SQL Server

... with some impressive SQL Server workloads, those databases are several hundred ... they also support SQL Server ! You can find the tool ... on your own SQL Server within a few minutes. After the ... Oracle MySQL Microsoft SQL Server You can set your actual database ... database system to SQL Server , you can ... can specify your SQL Server connection info, and ... a session in SQL Server . This option ...

23.11.2011 | 181 0

7

My new event series across Europe: SQL Server 2012 Deep Dive Days

... across Europe: the SQL Server 2012 Deep Dive Days. You can ... new things in SQL Server 2012. The event series is currently ... following topics about SQL Server 2012: Day 1: SQL Server 2012 Development Project Juneau T-SQL ... Databases Metadata Discovery SQL Server Integration Services Day 2: SQL Server 2012 Administration Extended Events ... Windows Server 8 & SQL Server 2012 Day 3: ...

17.11.2011 | 184 0

5

Why SQL Server is using so LESS memory

... memory management in SQL Server . A few weeks ago I ... we made some SQL Server performance improvements. As a side note ... asked me, why SQL Server isn't using as much memory as ... we saw that SQL Server was just consuming a few hundred ... this behavior of SQL Server was a little bit amazing, but ... account under which SQL Server was running. You can check ... into the current SQL Server Error Log. If ...

04.11.2011 | 60 0

6

Correction of my unfair and incorrect words against SQLWorkshops.com

On October 18, 2011 I have made unfair and incorrect words on Twitter, Facebook, LinkedIn, and Xing against the owners of SQLWorkshops.com. Because of this misbehavior of me, I got a so-called dissuasion letter from SQLWorkshops.com, which I have signed today, because I'm committing me now not to make such unfair and incorrect words any more in the future against ...

02.11.2011 | 111 0

6

Troubleshooting THREADPOOL Waits

... scheduling mechanism inside SQL Server . As you might know SQL Server internally uses its own "operating system" ... are submitted to SQL Server . The problem is that those ... In this case SQL Server isn't able to execute any more ... 0, which means SQL Server itself decides how many worker ... worker threads your SQL Server instance is using. With ... thread starvation in SQL Server and how you ...

25.10.2011 | 574 0

12

Query Memory Spills

... be granted by SQL Server before the query is actually executed. ... are out-of-date, and SQL Server underestimates the processed ... In this case, SQL Server will also request to ... In this case, SQL Server has to spill ... physical On-Disk operation. SQL Server Profiler will report ... Hash Warning. Unfortunately SQL Server 2008 (R2) provides ... Memory Spills. In SQL Server 2012 this will ...

19.10.2011 | 148 0

6

Slides & Samples for my Advanced SQL Server Troubleshooting session at SQLPASS

As I have announced in my "Advanced SQL Server Troubleshooting" session at SQLPASS today, you can find here the slides & samples for download. Thanks for attending my session J -Klaus

14.10.2011 | 111 0

7

Slides & Samples for my Advanced SQL Server Troubleshooting session at SQLPASS

As I have announced in my "Advanced SQL Server Troubleshooting" session at SQLPASS today, you can find here the slides & samples for download. Thanks for attending my session J -Klaus

14.10.2011 | 79 0

6

SQL Server Indexing Day, 18. Jänner 2012 in Wien

Sie wollen SQL Server Abfragen um 100% oder ... und Lizenzkosten Ihrer SQL Server Anwendungen und deren ... einer gut indizierten SQL Server Datenbank können Sie ... Hardwareanforderungen an Ihre SQL Server Infrastruktur und dadurch ... Lizenzkosten, die für SQL Server Installation anfallen. Am ... – unabhängigier SQL Server Experte und internationaler ... den SQL Server Indexing Day in ...

04.10.2011 | 85 0

0

SQL Server Indexing Day, 18. Jänner 2012 in Wien

Sie wollen SQL Server Abfragen um 100% oder ... und Lizenzkosten Ihrer SQL Server Anwendungen und deren ... einer gut indizierten SQL Server Datenbank können Sie ... Hardwareanforderungen an Ihre SQL Server Infrastruktur und dadurch ... Lizenzkosten, die für SQL Server Installation anfallen. Am ... – unabhängigier SQL Server Experte und internationaler ... den SQL Server Indexing Day in ...

04.10.2011 | 120 0

0

Slides & Samples from my SQLbits sessions

As I have announced in all of my sessions at the SQLbits conferences in Liverpool/UK, you can find here the Slides & Samples for download. Enjoy it and thanks for attending my sessions. J -Klaus

02.10.2011 | 132 0

5

Slides & Samples from my SQLbits sessions

As I have announced in all of my sessions at the SQLbits conferences in Liverpool/UK, you can find here the Slides & Samples for download. Enjoy it and thanks for attending my sessions. J -Klaus

02.10.2011 | 67 0

4

Slides & Samples for my SolidQ Summit Sessions

As I have announced in all of my sessions last week in Budapest at the SolidQ summit, you can find here the Slides & Samples for download. Enjoy it and thanks for attending my sessions J -Klaus

29.09.2011 | 68 0

Klaus Aschenbrenner - SQL Server Consulting

News und Artikel von Klaus Aschenbrenner - SQL Server Consulting