SQL Server Codename “Denali” CTP3 Resources
SQL Server codename “Denali” CTP3 has been released to the public after much anticipation. You may ask yourself, “What happened...
2011-07-13
2,753 reads
Blog Posts
SSIS package taking forever to load when you open it?
When you open a SQL Server Integration Services (SSIS) package in SSIS Designer or add components to a package, SSIS...
2011-07-13
2,583 reads
SSSOL July 2011 Reminder
This is just a quick note to remind anybody who may be interested of the upcoming Las Vegas User Group meeting. As I posted here, we will be learning...
2011-07-13
4 reads
SSSOL July 2011 Reminder
This is just a quick note to remind anybody who may be interested of the upcoming Las Vegas User Group...
2011-07-13
604 reads
We have a new contributor…
In order to keep the content fresh and the posts flowing here on my blog I have decided to publish...
2011-07-13
587 reads
Automating Web App Deployments with SSIS
This is just a quick note to let everyone know I’ve uploaded the project files from my Pragmatic Works webinar...
2011-07-12
609 reads
Copying parent-child rows and SQL Dependency Tracker
I was facing quite well-known issue today – I had to develop logic of duplicating (versioning) parent-child records. Because I was...
2011-07-12
2,103 reads
How to move the Model Database
First we need to know the name and file location of the Model database files. When you change the location, make...
2011-07-12
6,578 reads
SQL Server “Denali”: CTP3 now available!
CTP3 of SQL Server Code Name “Denali” was made available for download this morning. You can download the 32-bit and...
2011-07-12
2,245 reads
SQL Server 2008 R2 Service Pack 1 Released
Microsoft has finally (after releasing the CTP version way back in April) released the final, gold build of SQL Server...
2011-07-12
2,645 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