A Couple of Invoke-SQLCMD Issues
In working on a PowerShell script to load data into SQL Server, I decided to use the Invoke-SQLCMD cmdlet included...
2009-08-14
623 reads
Blog Posts
Book Review: The Coldest Winter: America and the Korean War
The Coldest Winter: America and the Korean War by David Halberstam ($15 at Amazon) was really the first reading I...
2009-08-14
689 reads
Evil Code
/*
A couple
of years ago, I wrote the Simple-Talk Prettifier. This is really no more than a stored
procedure that...
2009-08-14
3,553 reads
Kevin Kline Joins the SQLSaturday Advisory Council
The official announcement was just posted, Kevin Kline is the first member of the Advisory Council. As I mentioned on...
2009-08-14
1,045 reads
The Benefits of a Flexible Schedule
Both my wife and I work from home, and we've done it for years. I've been working full time for...
2009-08-14
982 reads
"Just smile and wave, boys. Smile and wave."
If you're not familiar with the reference, it comes from the movie Madagascar and the subsequent sequel and TV series...
2009-08-13
13,785 reads
Getting Into The Biz, Part 2
In a previous blog post, I began writing about how one might start a career as a database professional, and...
2009-08-13
617 reads
Microsoft at the PASS Summit
One of the reasons that I think the PASS Summit fits well in Seattle is the support that they get...
2009-08-13
920 reads
SQL Server Standard Writing Guidelines
Well, actually, these are the guidelines for submitting anything to SQLPASS, but it includes the guidelines for SQL Server Standard....
2009-08-13
1,171 reads
SQLSaturday #17 - Baton Rouge Session Evaluations
I guess I did a good job, with all 3s and 4s in my eval (meaning good and great) for...
2009-08-13
787 reads
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
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...
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