Writing a Question Of The Day–More Notes
Today I wrote another question based on an error message. I included the error message in the question this time...
2014-04-15
485 reads
Blog Posts
5 Years Running! OKCSQL!
I want to congratulate OKCSQL on a 5 year run.
I personally wasn't here for that whole duration, but we have leaders and...
2014-04-14
696 reads
Collation: Correction -> Instance
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-14
667 reads
Collation: Correction -> Instance
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-14
462 reads
It’s Not All About The Keys–Question Of The Day
My latest question is live today, called It’s Not All About The Keys. It’s a three pointer, if score matters...
2014-04-14
437 reads
Last Weeks Top “Reading” Links #79
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-04-14
716 reads
Listing the SQL Server SysAdmins With PowerShell
A very short blog today just to pass on this little script.
I was required to list all of the SysAdmins...
2014-04-14
534 reads
MidnightDBA at SQL Saturday Houston – May 10
Sean and I will be speaking at SQL Saturday Houston on May 10, at San Jacinto College – South Campus 13735...
2014-04-14
638 reads
Missing Database Owner
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-14
2,807 reads
Oracle Tips for MSBI Devs #6: Supporting SSAS Tabular Development
As SQL Server Analysis Services Tabular Models become more popular, models will use Oracle databases as sources. One of the...
2014-04-14
1,114 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