So I Got Promoted, Now What? Get To Know Your Peers
[This is part four in a series of posts about how to effectively transition to your new role after being...
2010-10-06
801 reads
Blog Posts
Speaking Ideas - Plan to End
Over the years I’ve seen probably hundreds of technical presentations. I’ve seen good ones, bad ones, on all sorts of...
2010-10-06
332 reads
SQL Saturday 58 Schedule Released
We technically released it on Monday but I didn’t want to blog about it for a couple days since we...
2010-10-06
740 reads
SQLSaturday #49 (Orlando) Is Right Around The Corner - Have You Registered?
As I write this SQLSaturday #49 in Orlando is right around the corner - October 16, to be exact. My friends...
2010-10-06
461 reads
Stop Forgetting the DAC
From time to time I hear of DBAs that had to restart the SQL Server service on a 2005 or...
2010-10-06
963 reads
Upcoming October Events
During October I’ll be presenting at several online and in-person events
LocationDateSessionSQL Saturday #49 Orlando 2010Oct 16th ETL with PowerShellPASS PowerShell...
2010-10-06
850 reads
VMWare vSphere database maintenance
I recently did a VMWare/SAN assessment for a client. The expressed reason, or the reason relayed to me (not always...
2010-10-06
3,934 reads
Converting Dates to Integers
While working on a project recently, I came across a conversion that was trying to convert a date to an...
2010-10-05
799 reads
How Do I Spot Identity Columns That Are About to Max Out?
Every so often, usually in the middle of the night or on a holiday weekend, an identity column will hit...
2010-10-05
1,250 reads
It’s Implied
This has been on my radar now for a little over a week. I ran across a request in the...
2010-10-05
743 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
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...
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