Not Pointing Fingers - Microsoft and Sidekicks
Someone posted a note on Twitter about the Sidekick fiasco. Apparently the servers that lost data weren't Microsoft servers. They...
2009-10-23
810 reads
Blog Posts
PASS Summit One Week Away
It’s just a week and a couple of days before I’ll be hopping a plane for Seattle and the 2009...
2009-10-23
582 reads
Some useful commands and sp for Transaction Replication
This blog is having some useful commands we use for replication and troubleshooting.
>>Some useful commands and stored procedures
How it works:
Log...
2009-10-23
18,478 reads
Some useful commands and sp I use for Transaction Replication:
I write several blog about replication and mansion commands and stored procedure related to transaction replication, but I would like...
2009-10-23
1,325 reads
SQLLunch – Accidental DBA and Performance Data Collector
If you haven’t had a chance to attend the SQL Lunch Live Meeting learning series then sign in Monday at...
2009-10-23
874 reads
SSRS - Setting Default Parameter Values for Analysis Services Datasets
When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult...
2009-10-23
7,083 reads
Sydney SQL Server Users Group Draws Big Crowd
On Tuesday, October 13, I spoke at the Sydney SQL Server Users Group, presenting on “How to Get the Most...
2009-10-23
498 reads
Tricks and issues Part 1
Today was browsing the Blog http://blog.sqlauthority.com/ Pinal Dave expert on Sql server and great Blog writer. Got surprise to see...
2009-10-23
636 reads
2009 PASS Conference Side Quests
Barring any unforeseen issues like sudden death, I'll attend this year's 2009 PASS conference in Seattle. I'll arrive Sunday the...
2009-10-22
816 reads
Book Review: The Board Book
I ordered the ' target=_blank>The Board Book from Amazon ($18) to try to get some ideas for how to do a...
2009-10-22
584 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
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...
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