Your Job Description
This Friday Steve Jones talks about job posting and descriptions. This is the chance to think about what you do and how you might describe this to your replacement.
Use T-SQL to Find Folders Using the Most Disk Space
Your SQL Server drives are running out of disk space and you want a way to quickly tell which sub-directories are taking the most space - here's how to do it with T-SQL.
Securing the Things
The Internet of Things is coming, and bringing lots of data, but security needs to be included as well.
Setting up R in SQL 2016 – Avoiding Pitfalls
Setting up R in SQL 2016 proved to be trickier than expected, but here is how to avoid the frustrations.
Questions About SQL Server Collations You Were Too Shy to Ask
Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is that it is a rather complicated topic to fully understand and the cost of getting collation wrong can be great. If only one could ask certain questions on forums or at conferences without blushing. Help is at hand, because Robert Sheldon once again makes the complicated seem simple by answering those questions that you were too shy to ask.
Stairway to U-SQL Level 15: U-SQL Global Scalar Functions With C#
In this article, see how to created shared functions using C# assemblies in U-SQL.
Setting Variables in Calling T-SQL Code While Using sp_executesql
In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers