I’m speaking at SQL Rally 2012
I’ve learned that my session entitled “Introduction to Data Quality Services” has been selected as one of the community choice...
2012-02-27
673 reads
Blog Posts
Learn Mirroring with me at SQLRally
I just found out that I will be speaking at SQLRally Dallas in May. I submitted 3 sessions. As an...
2012-02-27
664 reads
New Article: Exploiting SQL Server via CONTROL SERVER permissions
I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...
2012-02-27
1,736 reads
Passing BIGINT data to SSRS Sub Report
Few days back one of my team mate complained to me that one particular sub report is failing randomly with
Error:...
2012-02-27
1,453 reads
Presenting Two Sessions at SQLRally
I just received great news that one of my sessions, Attacking SQL Server, was picked by the community for SQLRally....
2012-02-27
980 reads
RYO Maintenance Plan – Update Statistics
Another key component of any good maintenance plan is updating statistics. Statistics are what help the SQL Server optimizer choose...
2012-02-27 (first published: 2012-02-21)
2,544 reads
SSRS 2008 Error – The report definition is not valid
Recently I downloaded a file from one of our production server, did some changes and reviewed it in BIDS and...
2012-02-27
4,706 reads
The Armor of Transparency
Yesterday I blogged about hosting a daily status meetings and some of the tricks I use to make it work....
2012-02-27
647 reads
How to remove new line character from string using SQL ?
In a varchar column some of the entries were showing space in the left side and even after using the...
2012-02-26
9,157 reads
SQL Saturday 108 (Redmond, WA) Session Files
SQL Saturday 108 (Redmond, WA) Session Files
SQL Saturday 108 Replication Magic
Session files are now available for download. The zip file...
2012-02-26
919 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