Speaking at the Baltimore SQL Server User Group
On Monday, the first of February, 2010, I will be speaking at the Baltimore SQL Server User Group meeting at...
2010-01-27
488 reads
Blog Posts
SQL Saturday #34
The event is this Saturday. Take a look at our sponsors, speakers and the program. It’s going to be a...
2010-01-27
590 reads
Wildcards in WHERE Clauses
This is just a very short post regarding the use of wildcards in a WHERE Clause
It is possible that the...
2010-01-27
591 reads
Another Keyboard Down
I don’t know if they’re making them cheaper and shoddier or what, but it seems that I’m going through a...
2010-01-26
906 reads
Database Normalization
Normalization :- Normalization can be defined as the process of organization the data to reduce the redundant table data to the...
2010-01-26
2,809 reads
2010-01-26
359 reads
First Normal form (INF)
First Normal Form (INF):- A table is said to be in a First Normal Form (1NF)if it satisfy the following...
2010-01-26
793 reads
How to Participate in the SQL Community – Draft #1
I mentioned last year about my plans to write this, and to make it a semi-collaborative effort by incorporating comments...
2010-01-26
590 reads
Indexes Out the Window II
In Part I, I discussed some of the peculiarities and troubleshooting done in relation to a peculiar execution plan. In...
2010-01-26
847 reads
It’s a Toaster
I had to install WinZip the other day, having the need to unlock a .RAR file. There’s no native support...
2010-01-26
1,161 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers