The Showdown
Today we have a guest post from Steve Jones.
I survived SQL in the City in LA, and thanks to everyone...
2011-10-31
1,555 reads
Blog Posts
Two of a Kind
Here’s one that I haven’t run into before. A colleague scheduled a meeting with someone else in the organization to...
2011-10-31
1,670 reads
Creating a Table Report with Dynamic Columns
Over time, similar reports may be designed from variations of common queries and datasets. Creating one report to meet all...
2011-10-30
2,746 reads
Logical CPU, Physical CPU and hyper threading
Those who are fan of Glenn Berry’s DMV queries would have come across below query at-least once.
-- Hardware information from...
2011-10-30
11,514 reads
DATABASE_OBJECT_CHANGE_GROUP do not audit SP or other object
Deepak Kumar (friend of mine and founder of http://www.sqlknowledge.com ) were chatting yesterday. We were discussing about audit feature in SQL...
2011-10-29
1,852 reads
Finding orphaned database users
Database users can become orphaned for a few reasons. For example, a database restore to another instance or deleting the...
2011-10-29
1,614 reads
Updatable Subscriptions Deprecated in SQL Server 2012
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
4,035 reads
Updatable Subscriptions Removed in SQL Server 2012
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
2,005 reads
A Thought on Career Decisions
One of the many conversations I had at the PASS Summit was about whether to pursue Direction A or Direction...
2011-10-28
641 reads
Convert comma separated string to table and vice versa
I know that this subject has been blogged about numerous times but I thought I'd post an alternative way of...
2011-10-28
9,049 reads
Blogs
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...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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