Bad Default Database Leads to a Failed Login Attempt
Yesterday we had a user receiving the infamous failed login attempt error (no, that's not a valid IP):
Login failed for...
2010-01-07
1,714 reads
Blog Posts
Book Review: SQL Server 2008 Query Performance Tuning Distilled
I recently finished reading the Apress book SQL Server 2008 Performance Tuning Distilled by Grant Fritchey and Sajal Dam. I...
2010-01-07
1,342 reads
Error rsAccessDenied : The permissions granted to user 'Toma-PC\Toma' are insufficient for performing this operation.
In my problem of the day, I found this one out on the Microsoft Reporting Services Forum. I bumped my head...
2010-01-07
24,000 reads
Handling Database Mirror Failover within an SSIS Package
Recently I was asked how to handle a Mirrored Database Failover within an SSIS package. For those of us that...
2010-01-07
2,571 reads
How to Read the Results of SELECT @@VERSION in SQL Server
The simple query SELECT @@VERSION can quickly tell you quite a bit about a SQL Server installation (and the underlying...
2010-01-07
4,124 reads
Recharging
I was hoping that 4 days in the mountains would be a nice time to recharge. Unfortunately, with my wife...
2010-01-07
445 reads
Speaking at SQLSaturday #32 in Tampa on January 23, 1010
I’ll be heading to Tampa the afternoon of the 22nd for the speaker party, and then presenting Social and Not...
2010-01-07
325 reads
SSC Syndication
Steve Jones at SqlServerCentral.com has created a Blog for me over there at SqlServerCentral.com. I will be syndicated there and...
2010-01-07
606 reads
Too Much Data – Idiocracy or Star Trek?
I used to think that too much data was never a bad thing. That having more information out there is...
2010-01-07
369 reads
10 Goals For 2010
As is the traditional thing to do at the beginning of a new year I'm making goals for what I'd...
2010-01-06
708 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