SQL Server Column Level Encryption Example using Symmetric Keys
With data stored in tables, you have a few options to protect data. Check out this tip to learn more about column level encryption.
Jacks of all trades
Instagram has a complex architecture for it's technology infrastructure. The people that work there have to be jacks of all trades. Is that the type of environment you'd like to work in?
Using Recursion and Date Tables to Simplify Date Logic
Learn to simplify date logic using date tables and recursion in T-SQL with this article from David Beardsley.
Reduce heap table fragmentation
A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table.
SQL Server Database Growth and Autogrowth Settings
It's easy to create a database nowadays with point-'n-click, but if you've left your database's autogrowth settings at their default, you may hit problems in the future. Why? What do I do about it? Read on!
Vote for SQL Bits 10
Voting is now open to choose the sessions you would like to see at the SQLBits Community Day on 31st March, 2012.
A C# toolkit for writing SSIS Script Tasks
This article demonstrates basic C# code that will enable SSIS package developers to write useful custom SSIS script tasks.
Does the Role of the DBA Need to Evolve?
With the amount of data being stored expanding exponentially, does the role of the DBA need to change from caretaker to interpreter?
Encryption Works
Encryption is supposed to protect data, and it appears to be working as police and authorities are often stymied by encrypted disks. Steve Jones recommends you encrypt your disks on all your machines.
Blogs
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...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
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
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers