SQL Saturday Advice - PhotoJournalism
I try to carry a camera, and a video camera, most of the time when I’m traveling. I have a...
2010-09-02
372 reads
Blog Posts
Thanks for supporting this blog and make it successful
Hi friends
Thank you very much for supporting this blog. It really give me lots of encouragement to share my knowledge...
2010-09-02
767 reads
Whats best SQL Server or Oracle ?
Im often asked the question – whats best SQL or Oracle ?
The Oracle guys will tell you that SQL Server does not...
2010-09-02
603 reads
A Stored Procedure to Move SSIS Packages Between Servers
This post provides the code for a stored procedure to move SSIS packages between SQL 2005 SSIS servers. Continue reading ?
2010-09-01
12 reads
A Stored Procedure to Move SSIS Packages Between Servers
Today’s post is one that I have been debating on whether to publish for a while. The purpose of the...
2010-09-01
981 reads
A Stored Procedure to Move SSIS Packages Between Servers
This post provides the code for a stored procedure to move SSIS packages between SQL 2005 SSIS servers. Continue reading ?
The post A Stored Procedure to Move SSIS Packages...
2010-09-01
3 reads
As a PASS Member, Don’t Forget to Vote in the 2010 PASS Board Elections
I just received my e-mail from PASS, which says, “As a PASS Member in Good Standing, you are entitled to...
2010-09-01
592 reads
Book Review: Crunch Time
About a month ago I went to Barnes & Noble to pick up a copy of Seth Godin’s book, Tribes: We...
2010-09-01
579 reads
Common SQL Server Mistakes - SELECT *
I’ve been trying to work on some new presentations so that I have a variety, including some spares, when I...
2010-09-01
4,399 reads
Creating a PerformancePoint 2010 Data Source
In a previous post I wrote about getting started with PerformancePoint 2010.In that post you learned about what PerformancePoint is...
2010-09-01
898 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