Undocumented Virtual Column: %%lockres%
One of my development teams needed a mechanism for identifying the value of a key that was part of a...
2010-03-18
4,669 reads
Blog Posts
Want to Learn More About How to Master Microsoft Technologies?
If you want to learn more about how to master various Microsoft technologies, visit the website Born to Learn. This...
2010-03-18
1,435 reads
Automating Imports from Access
Access is actually pretty good at importing files, and doesn’t on the surface work much different that import/export from Management...
2010-03-17
872 reads
Minimizing Fragmentation when Moving data using a Switch
Yesterday was the first day of the SQL Server 2008 R2 airlift.I attended a great session on Implementing a Fast...
2010-03-17
814 reads
SQL Saturday – A Few Lessons for Future Events
I’ve been to a few SQL Saturdays, and while most have run smoothly, I have a few comments on a...
2010-03-17
874 reads
Using SSAS MDX Calculation Color Expressions
Analysis Services calculations are great for storing formulas that your users need to see on a regular basis. They also...
2010-03-17
6,076 reads
A Wiki Wiki
I was killing a few minutes browsing while waiting on a call, had been thinking again whether a wiki would...
2010-03-16
699 reads
Dynamically Adding and Removing Columns to a Query and Report
Creating one report to meet multiple business requirements can save a lot of work
down the road. A common scenario is...
2010-03-16
811 reads
Enabling Filestreaming in SQL Server 2008
This is a short post on enabling file streaming. I have read a few sources that cover the same topic...
2010-03-16
741 reads
How to Enroll a Managed Instance into SQL Server Utility in SQL Server 2008 R2
After creating a Utility Control Point (UCP) you will want to enroll some managed instances (up to 25 with SQL...
2010-03-16
1,299 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