Using SQL Server Dynamic Online Catalog to Solve Problems: Stairway to Exploring Database Metadata Level 2
In this second level of the Stairway, Phil looks at where we go to find information about objects, using triggers as the example.
What is SSIS? Level 1 of the Stairway to Integration Services
Learn about the very basics of what Integration Services is and how it's used in SQL Server.
What is StreamInsight and why does it matter?
An introduction to SQL Server StreamInsight and Complex Event Processing with a focus on Business Intelligence.
Creating CRUD Stored Procedures in SQL
Back to the basics: learn how to Create, Read, Update and Delete operations are pivotal for any database application. Plus, you’ll see how to use Stored Procedures to manipulate data on the database side instead of on the application side.
Query Tuning Assistant: A Tool for Upgrades
If you have been working with SQL Server long enough, you have probably been involved with a SQL Server 2000 to 2005 upgrade. It was painful for many shops due to the deprecation of some features like DTS and the removal of old-fashioned comma joins with the plus operator. It was worth the pain as […]
What's Worse than Announcing a Data Breach?
Steve has a few thoughts on what is worse than telling your boss about a data breach.
Introduction to SQL for Cosmos DB
This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer. More specifically it will show you how to leverage your Structured Query Language skills to exploit the core possibilities of Cosmos DB as a NoSQL document database.
Can deleting rows make a table…bigger?
Michael J. Swart posted an interesting question: he had a large table with 7.5 billion rows and 5 indexes. When he deleted 10 million rows, he noticed that the indexes were getting larger, not smaller.
SQL Server Reporting Services Lookup, LookupSet and MultiLookup Functions
I noticed the Lookup function in SQL Server Reporting Services. In this tip we look at all three SSRS lookup functions: Lookup, LookupSet and MultiLookup.
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
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
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
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers