SQL Server 2012 (“Denali”): Installing on a Virtual Machine
With CTP3 for SQL Server 2012 (code name of “Denali”) available, a lot of us want to play with all the new...
2011-09-14
1,637 reads
James Serra's Blog
How to prevent blocking in your SQL Server database
As a SQL Server DBA, usually the largest databases in size and in number of users that I had to manage was an ERP...
2011-09-12
824 reads
Using a Display Folder for a SSAS calculation
I was having a problem getting the display folder to work for a calculation in SSAS. Turns out, it will...
2011-09-09
1,368 reads
Thinking about taking a contract position? Questions to ask
Over the years, I have accumulated a set of questions that I usually ask the placement firm about a contract position...
2011-09-07
1,158 reads
System Center and Visual Studio Team Foundation Server 2010
Because the relationship between application development and the IT operations teams is critical, Microsoft has released a CTP of a new...
2011-09-06
1,080 reads
Preventing projects from deploying when debugging a SSIS package
This is a quick tip to help quickly solve a problem I run into sometimes, and now that I am...
2011-09-02
1,412 reads
Receive error #13119 in toolbox instead of tools in Visual Studio 2008
A couple of times over the past few months, while in Visual Studio 2008 working on an SSIS package, I went...
2011-08-31
2,153 reads
When to use T-SQL or SSIS for ETL
When doing ETL, you have the choice of using T-SQL or SSIS. What things should you consider when deciding which...
2011-08-29
10,231 reads
Microsoft SQL Server Parallel Data Warehouse (PDW) Explained
Microsoft SQL Server Parallel Data Warehouse (PDW), formally called by its code name “Project Madison”, is an edition of Microsoft’s SQL Server...
2011-08-26
3,812 reads
Microsoft Small Basic
This is a bit off-topic, but I wanted to mention a great tool for beginners to learn how to program. ...
2011-08-24
2,047 reads
Blogs
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
Forums
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
The New Database CheckDB
Comments posted to this topic are about the item The New Database CheckDB
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers