-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

T-SQL Tuesday #102: Giving Back

Last month we had the opportunity to discuss some of the most important tools for a data professional. I took that opportunity to discuss how it is important to blog. As it turns out, that article correlates fairly strongly to today’s article.

This are maybe some of the questions… Read more

0 comments, 139 reads

Posted in SQL RNNR on 9 May 2018

Change SQL Server Collation – Back to Basics

One of my most favorite things in the world is the opportunity to deal with extremely varying database and environment requirements. Many vendors and databases seem to have a wide swath of different requirements. Some of the reasons for these requirements are absurd and some are not. That is a… Read more

4 comments, 2,303 reads

Posted in SQL RNNR on 12 April 2018

T-SQL Tuesday #101: Essential Tools

What are the tools you love to use? What are the tools that maybe need a little sharpening? What tools do you have that maybe you wish were the same caliber as somebody else’s tools? And lastly, which tools do you not possess that you wish you possessed?

This are… Read more

0 comments, 208 reads

Posted in SQL RNNR on 10 April 2018

Syspolicy Phantom Health Records

SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system health data. I would dare say this job is ignored by most people and few probably even know it exists.

This topic is not new to me. You may recall… Read more

0 comments, 1,428 reads

Posted in SQL RNNR on 6 April 2018

SQL Server Extended Availability Groups

It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may be no surprise to many that Microsoft has also hastened the patch cycle for SQL Server.

If you were unaware of this, consider this as your notice that Microsoft has… Read more

1 comments, 231 reads

Posted in SQL RNNR on 1 April 2018

Extended Events File Initialization Failure

It should come as no surprise that I write a lot of articles about Extended Events (XE). This happens to be another article on Extended Events. Truth be told, this article is hopefully something that is more of an edge case scenario. Well, I sure hope that is the case… Read more

1 comments, 1,581 reads

Posted in SQL RNNR on 9 March 2018

Profiler for Extended Events: Quick Settings

Not long ago, I wrote a rather long article about a new-ish feature within SQL Server Management Studio (SSMS) that impacted Extended Events. You can read that book – here! The XEvents Profiler feature is one of those things that you may or may not use. If you consider… Read more

1 comments, 1,648 reads

Posted in SQL RNNR on 5 March 2018

SQL Server User Already Exists – Back to Basics

One of my all-time favorite things in SQL Server is security. No matter what, it always seems that there is a new way to abuse permissions. When people abuse their access level or abuse the way permissions should be set in a SQL Server environment, we get the pleasure of… Read more

1 comments, 261 reads

Posted in SQL RNNR on 24 January 2018

Database Corruption and IO Errors

A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is to come in one day to find that users are panicked, applications are not working and the HelpDesk team is curled up in the fetal position in the corner. Why?… Read more

2 comments, 299 reads

Posted in SQL RNNR on 18 January 2018

Checking the Health of your CLR

The Common Language Runtime (CLR) is the fundamental nerve center of the Microsoft .NET Framework. It is this nerve center that provides the execution environment for all .NET Framework code. One may sometimes refer to CLR code as managed code.

CLR hosted from within SQL Server (CLR Integration), provides the… Read more

1 comments, 226 reads

Posted in SQL RNNR on 16 January 2018

SQL Server Configurations – Back to Basics

One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would be called defaults. Having default settings is not a bad thing nor is it necessarily a good thing.

For me, the defaults lie somewhere in the middle ground and they… Read more

0 comments, 267 reads

Posted in SQL RNNR on 11 January 2018

Summiting that Technical Challenge

Conquering Challenges

I really like the topic of the TSQLTuesday party today. Today we have been instructed in no uncertain terms to share a technical challenge with the world with which we were confronted. Ideally we will have conquered that challenge. Sometimes, we may not have conquered the technical challenge.… Read more

0 comments, 907 reads

Posted in SQL RNNR on 10 January 2018

Common Tempdb Trace Flags – Back to Basics

Once in a while I come across something that sounds fun or interesting and decide to dive a little deeper into it. That happened to me recently and caused me to preempt my scheduled post and work on writing up something entirely different. Why? Because this seemed like fun and… Read more

1 comments, 330 reads

Posted in SQL RNNR on 6 January 2018

Changing Default Logs Directory – Back to Basics

Every now and then I find a topic that seems to fit perfectly into the mold of the theme of “Back to Basics”. A couple of years ago, there was a challenge to write a series of posts about basic concepts. Some of my articles in that series can be… Read more

0 comments, 1,302 reads

Posted in SQL RNNR on 5 January 2018

Sharepoint Diagnostics and XE

One of the all-time greatest and most beloved applications among DBAs happens to be Sharepoint. Most of us would be lying if we said that we loved Sharepoint and the kind of performance issues it can cause on a SQL Server.

When you have an application that comes with a… Read more

2 comments, 417 reads

Posted in SQL RNNR on 4 January 2018

Dynamics AX Event Session

Many moons ago, I wrote about how to enable the context info for Dynamics AX. Having the context info enabled is a pretty important thing when dealing with Dynamics AX. The amount of time you can save yourself and the DAX Admins is astounding – if you have the context… Read more

0 comments, 963 reads

Posted in SQL RNNR on 3 January 2018

Correlate SQL Trace and Actions

I have recently written about the pains of correlating SQL Trace events to Extended Events (XE) events. That article can be found here. At that time, I did not dive into another facet of trace that truly needs converting as well. That component is known as “Actions” in the… Read more

0 comments, 328 reads

Posted in SQL RNNR on 1 January 2018

Correlate SQL Trace and Actions

I have recently written about the pains of correlating SQL Trace events to Extended Events (XE) events. That article can be found here. At that time, I did not dive into another facet of trace that truly needs converting as well. That component is known as “Actions” in the… Read more

0 comments, 180 reads

Posted in SQL RNNR on 1 January 2018

Correlate SQL Trace and Actions

I have recently written about the pains of correlating SQL Trace events to Extended Events (XE) events. That article can be found here. At that time, I did not dive into another facet of trace that truly needs converting as well. That component is known as “Actions” in the… Read more

0 comments, 182 reads

Posted in SQL RNNR on 1 January 2018

Correlate SQL Trace and Actions

I have recently written about the pains of correlating SQL Trace events to Extended Events (XE) events. That article can be found here. At that time, I did not dive into another facet of trace that truly needs converting as well. That component is known as “Actions” in the… Read more

0 comments, 181 reads

Posted in SQL RNNR on 1 January 2018

Older posts