SQL Server 2012 (“Denali”) Licensing
Microsoft has posted the licensing for SQL Server 2012. It has simplified licensing: SQL Server 2012 will offer two licensing...
2011-12-02
1,488 reads
Microsoft has posted the licensing for SQL Server 2012. It has simplified licensing: SQL Server 2012 will offer two licensing...
2011-12-02
1,488 reads
On Windows 2008 R2 , a System Reserved Partition is created. It is 100 MB and acts as a preparatory step...
2011-12-02
1,026 reads
An Automagic Index Creation Script? No, but a start to deal with Missing IndexesHere's the useful join from a number...
2011-12-02
1,987 reads
Problem
A report developed using SSRS 2008 either through Visual Studio 2010 or BIDS 2008 does not renders properly when viewed...
2011-12-02
5,957 reads
Database Mirroring is a popular high availability solution and low-cost alternative to clustering, especially for smaller shops who can't afford...
2011-12-01
4,492 reads
This is a continuation of my DBA in Space journal.
Episode nine was filmed in the “Mars” exhibit. In this scene,...
2011-12-01
619 reads
December is the last month of the year, and is often a good time to reflect on the past year...
2011-12-01
1,171 reads
It’s been a slow few weeks since my last update. This week I did a call with Karla and Wes...
2011-12-01
427 reads
Today the slate of candidates for the 2012-2013 term was announced;
Adam Jorgensen, Denise McInerney, Geoff Hiten, Kendal Van Dyke,...
2011-12-01
637 reads
I’m probably going to have to put together a new SQL video, because I’ve been accepted to speak at SQL...
2011-12-01
550 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
There is a table tblItems with below structure ( i cannot change the below...
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers