Spaces in Object Names Revisited
I think in general the SQL Server DBA’s of the world prefer that object names not have spaces embedded, and...
2009-10-05
814 reads
Blog Posts
Speaking Engagements This Week
I'll be doing three talks this week, starting tomorrow (Tuesday).
Tuesday, October 6th, Midlands PASS Chapter - Trigger Happy Database Security(PASS Summit...
2009-10-05
983 reads
SQL Lunch Starting at 11:30 AM CST 10/5/2009
TOPIC: SQL Lunch - Memory Management in SQL Server Analysis Services
If you haven’t already, go out and register for today’s SQL...
2009-10-05
730 reads
SQL Saturday #21 – Orlando
Well we are less than two weeks away from SQL Saturday #21 in Orlando, FL. My bags are packed and...
2009-10-05
531 reads
SQL Server 2008 Change Data Capture
SQL Server 2008 has a new Change Data Capture feature that allows you to track Inserts, Updates, and Deletes on...
2009-10-05
2,380 reads
A Hint For Recruiters (And You!)
Over the past few years we’ve had a number of recruiters and staffing firms visit oPASS as sponsors, and we...
2009-10-04
349 reads
SQLSaturday 26 Session Files
SQLSaturday 26 Sessions: 10/3 in Redmond, WA
Thanks to everyone that attended my sessions at SQLSaturday 26 in Redmond, WA on...
2009-10-04
1,024 reads
Stupid DBA Tricks
Well, I just learned a valuable lesson about something you should not do as a DBA…
About a month ago, a...
2009-10-04
4,340 reads
Pitching in at SQL University
Jorge Segarra (@SQLChicken) has put together an idea to have on-line basic lessons on SQL Server called SQL University. The idea...
2009-10-03
1,125 reads
Red Gate's SQL Data Generator
I'm reading SQL Server MVP John Magnabosco's new e-book, Protecting SQL Server Data, and he includes a database schema to...
2009-10-03
3,036 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