|
|
-
|
|
This post is a quick tip to find the version of Windows Installer installed on your box.
You might wonder why I ever need to check this version, so here is my small story -
Today I was installing SQLServer 2008 Upgrade advisor for a Windows Server 2003(SP2...
|
|
-
|
|
The prerequisite SQLServer 2008 R2 patch level for System Center Config Manager 2012(SCCM) is SP1 with Cumulative Update 6 (CU)
For a fresh install if you are considering the latest SQLServer 2008 R2 SP2 for SCCM 2012,then you need to understand t...
|
|
-
|
|
SSMS reports are one of the best ways to pull some great deal of Server level or Database level information within SQLServer.
Today I was running the ‘Disk Usage’ report (This one is my favorite) for one of the database and immediately got this...
|
|
-
|
|
Recently I was doing a pretty large SQL 2012 deployment, and was doing some research on capacity specifications.
There were lot of numbers which I found really interesting and some were really new to me. I thought it would be worth sharing them.
Maximum D...
|
|
-
|
|
Today I opened SSMS in one of my SQL 2005 box,and to my surprise I got this error right away
“The file C:\WINDOWS\Microsoft.NET\Framework\%version%\mscorlib.tlb could not be loaded.”
I was running SQL 2005 SP3 (Yes,you heard it right !) and the only .NET f...
|
|
-
|
|
From last night I have been doing lot of planning to setup a virtual environment on my laptop.It was kind a little complex one as I will be dealing with 3 VM’s on the laptop.One has to be setup as a domain controller and a windows cluster has to be s...
|
|
-
|
|
Today there was an interesting question on max_files column value which is available under sys.traces view object.The question was like this -
max_files in sys.traces is 0 and that means zero, not NULL – correct?
Before we get into the details,I wou...
|
|
-
|
|
Today I decided to leverage performance dash board report for my SQL Server 2008 R2 instance and SQL 2012 RC 0 Instances.
SQL 2008 R2 RTM
I downloaded the msi file and ran setup.sql under SQL 2008 R2 RTM instance. Straight away I was hit by the error
Ms...
|
|
-
|
|
Today I came across some tools which does smart way of formatting your SQL code.Who does’nt like a code which is well formatted and easy to read.
I remember my college days when I used to write multiple lines of code for my final semester project ...
|
|
-
|
|
Partial database availability is an exiting feature,and I decided to write this blog post after observing many doubts related to this feature in forums.
Lets assume a situation like mentioned below -
We have a database with multiple file groups and dat...
|
|