Size of the DB limit has changed...
The cool update from SQL Server 2008 R2 is the possibility from Express Edition that changed the database limit from...
2010-04-26
729 reads
Blog Posts
SQL Server 2005 Diagnostic Information Queries (April 2010)
Since SQL Server 2008 R2 has gone RTM, and will soon be available for purchase, I am going to be...
2010-04-26
988 reads
SQL Server 2008 R2 Books OnLine - available now...
SQL Server 2008 R2 is released on April 21st, 2010 and in parallel with this new release, now is available...
2010-04-26
2,930 reads
SQL University: Auditing SQL Server, Part I
Welcome to the Security and Auditing Week for SQL University. Last semester we looked at the basics of SQL Server...
2010-04-26
2,787 reads
SQLSaturday Sites Will be Offline For Part of April 27, 2010
We’re scheduled to begin moving web sites and data to PASS servers at 12:00 pm Eastern on April 27, 2010....
2010-04-26
489 reads
SQLSaturday Success! NYC #39, has left the building.....
Well, it’s Monday morning and back to the DBA salt mines!
Now that SQLSaturday #39 is all but a joyful...
2010-04-26
571 reads
SSIS : Conditional Split optimization
I have built an enormous number of packages for this project over the past few weeks (just over 60) and...
2010-04-26
552 reads
SSIS : Using the VariableDispenser object within Script Components
I have become accustom to modifying package variables within my Script Task using the VariablesDispenser object. It is convenient and powerful. I started working...
2010-04-26
3,087 reads
SSIS : Using the VariableDispenser object within Script Components
I have become accustom to modifying package variables within my Script Task using the VariablesDispenser object. It is convenient and powerful. I started working...
2010-04-26
1,556 reads
Upgrading your Beta/CTP Software
This is one of the reasons that I don’t like to put CTP software (or Beta software) onto machines that...
2010-04-26
1,159 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