| 

.NET C# Java Javascript Exception

Klaus Aschenbrenner - SQL Server Consulting

Über den Autor
Klaus Aschenbrenner provides SQL Server Consulting services across Europe and the US. He helps people around the world to understand, use, and run SQL Server installations in their environments.
Webseite des Autors Themen des Autors
.net .net-german alwayson conferences databasemirroring replication sqlmcm sqlserver sqlserverpedia sqlserverquickie travel
Auf codekicker News finden Programmierer redaktionell vorausgewählte und daher hochwertige Artikel zu verschiedenen, auswählbaren Themen. Auch dieser Autor veröffentlicht seine Artikel auf codekicker News.

» News weiterer Autoren
» Auch Autor werden


News und Artikel von Klaus Aschenbrenner - SQL Server Consulting

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 ...
.net .net-german sqlmcm sqlserver sqlserverpedia
13.02.2013 | 261 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
.net .net-german sqlserver sqlserverpedia sqlserverquickie
16.12.2012 | 320 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 ...
.net .net-german conferences sqlserver sqlserverpedia
10.12.2012 | 371 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
.net .net-german sqlserver sqlserverpedia sqlserverquickie
16.10.2012 | 223 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, ...
.net .net-german sqlserver sqlserverpedia
27.09.2012 | 264 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
.net .net-german sqlserver sqlserverpedia sqlserverquickie
18.09.2012 | 265 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 ...
.net .net-german conferences sqlserver sqlserverpedia
21.08.2012 | 263 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 ...
.net .net-german replication sqlserver sqlserverpedia
05.08.2012 | 264 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
.net .net-german sqlserver sqlserverpedia sqlserverquickie
04.08.2012 | 230 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 ...
.net .net-german sqlserver sqlserverpedia sqlserverquickie
01.08.2012 | 252 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 ...
.net .net-german databasemirroring sqlserver sqlserverpedia
27.07.2012 | 278 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 ...
.net .net-german alwayson sqlserver sqlserverpedia
26.07.2012 | 342 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 ...
.net .net-german conferences sqlserver sqlserverpedia
25.07.2012 | 285 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 ...
.net .net-german alwayson sqlserver sqlserverpedia
23.07.2012 | 310 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 ...
.net .net-german sqlserver sqlserverpedia
19.07.2012 | 300 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 ...
.net .net-german sqlmcm sqlserver sqlserverpedia
03.07.2012 | 261 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 ...
.net .net-german sqlserver sqlserverpedia
25.06.2012 | 239 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: ...
.net .net-german conferences sqlserver sqlserverpedia
20.06.2012 | 256 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 ...
.net .net-german sqlserver sqlserverpedia
13.05.2012 | 317 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
.net .net-german conferences sqlserver sqlserverpedia
12.05.2012 | 258 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
.net .net-german conferences sqlserver sqlserverpedia
05.04.2012 | 323 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
.net .net-german conferences sqlserver sqlserverpedia
01.04.2012 | 296 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
.net .net-german conferences sqlserver sqlserverpedia
26.03.2012 | 287 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 ...
.net .net-german sqlserver sqlserverpedia
21.03.2012 | 427 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
.net .net-german conferences sqlserver sqlserverpedia
19.03.2012 | 263 0
12345...6