Getting Up To Speed on SQL Server Denali
Now that the Denali CTP has been out for several months, Brad asks how you're planning on getting up to speed on the latest version of SQL Server
TSQL Challenge 50 - Extracting a specifical range from random data wit
The purpose of this challenge is to test your query writing skills with a limited set of TSQL keywords.
What's Your Code Quality?
Today we have an editorial reprinted from Jan 3, 2006 as Steve is on vacation. What's the quality of your code? Do you measure it? And does it matter?
Understanding SQL Server 2008 R2 Fixed Database Level Roles
To easily manage the permissions in SQL Server databases, Microsoft has provided several roles in SQL Server which are security principals that group other principals.
Deleting Large Number of Records
Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005
Column-Level Encryption in SQL Server
Beginning with SQL Server 2005, column-level encryption and decryption capabilities were made available within the database, providing a solution for situations where one-off types of data need to be secured beyond your existing authorization, authentication or firewall settings. This article provides an overview and example of securing a column using native SQL Server cryptography functions.
Corporate Culture
One of the things I enjoy about work is seeing the various cultures that evolve. Some companies are rigid, some...
The Stairway Series
SQLServerCentral launches a new series of content today, aimed at helping you bootstrap your knowledge in specific areas of SQL Server.
The Stairway Series
Today we launch a new series of content aimed at providing basic knowledge to people new to a section of SQL Server. Steve Jones comments on the way this series came about.
Blogs
Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
Forums
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
What Power BI DirectQuery does to your SQL Server (and how to fix it)
Comments posted to this topic are about the item What Power BI DirectQuery does...
The New OS Wars
Comments posted to this topic are about the item The New OS Wars
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers