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

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

0 comments, 195 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, 258 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

0 comments, 179 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, 212 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, 845 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, 279 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,189 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, 360 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, 891 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, 263 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, 141 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, 144 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, 129 reads

Posted in SQL RNNR on 1 January 2018

Failed to Create the Audit File

One day while checking things for clients, I happened across a fun little error message – “SQL Server Audit failed to create the audit file“. It just so happens that the audit had been working and then suddenly stopped and started flooding the error logs with this message. Read more

0 comments, 139 reads

Posted in SQL RNNR on 31 December 2017

Failed to Create the Audit File

One day while checking things for clients, I happened across a fun little error message – “SQL Server Audit failed to create the audit file“. It just so happens that the audit had been working and then suddenly stopped and started flooding the error logs with this message. Read more

0 comments, 310 reads

Posted in SQL RNNR on 31 December 2017

An Introduction to Templates

Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to the largest cruise ships in the world, templates can be found everywhere in just about everything that do.

In SQL Server, templates are readily available for your use in so… Read more

0 comments, 339 reads

Posted in SQL RNNR on 30 December 2017

An Introduction to Templates

Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to the largest cruise ships in the world, templates can be found everywhere in just about everything that do.

In SQL Server, templates are readily available for your use in so… Read more

0 comments, 70 reads

Posted in SQL RNNR on 30 December 2017

Audit Domain Group and User Permissions

No matter how simple the task or how versed we are with doing a security audit, it seems like we can always stand to learn just a little bit more. No matter how many times we hand an audit report over to the auditor, there is always “just one” more… Read more

2 comments, 76 reads

Posted in SQL RNNR on 29 December 2017

Audit Domain Group and User Permissions

No matter how simple the task or how versed we are with doing a security audit, it seems like we can always stand to learn just a little bit more. No matter how many times we hand an audit report over to the auditor, there is always “just one” more… Read more

2 comments, 631 reads

Posted in SQL RNNR on 29 December 2017

Correlate Trace and XE Events

Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler or Server Side trace to something meaningful and useful within Extended Events.

That was years ago and really is ancient history now. Microsoft has provided a couple of maps to… Read more

0 comments, 210 reads

Posted in SQL RNNR on 28 December 2017

Older posts