In theory we cannot backup the log of a database which is in Simple recovery model, however there is a small bug in SQL 2012 which allows you to do this, and you need to be very careful about this.
Below is the detailed repro steps for this issue and… Read more
You will hit this error Cannot assign a default value to a local variable in case you are running SQL 2005/below,and you try to declare a variable and assign it a value in one statement.
Something like -
DECLARE @Var Varchar(15) = 'Test'
Msg 139, Level 15, State 1, Line… Read more
One of the advanced Server level options for SQL Server is Max Text Replication Size and this is really not a common one. In most of cases the default value is not changed.
This configuration specifies the maximum size of data that can be added to a replicated column in… Read more
Back to back quality SQLServer sessions! Yes, you heard it right and that’s what 24 Hours of PASS is all about.
The event kicks off at 12:00 GMT on Sep 20 and runs for 24 consecutive hours.
The sessions are selected carefully, and are categorized into 6 tracks -
Enterprise… Read more
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 the fact that SP2 includes… Read more
SSMS Report Error – Index(zero based) must be greater than or equal to zero and less than the size of argument list !
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 error!
Error – Index (zero based)… Read more
In this blog post we will discuss some crucial information related to… Read more
How many SQL Servers you run within your environment ? – MAP could be your best bet to answer this question !
A blog post about Microsoft Assessment Planning Toolkit was in my list for quite a while and today I decided to write about it.
Let’s assume that you are working for a pretty large organization and there are a lot of database servers running within the environment.
One fine day… Read more
Many times I have seen this question coming from users - Can I still buy per socket licenses for installing SQL2008 R2 ?
This question comes into the mind as SQL 2012 is already out and there is no more per socket based licensing model for the same.SQL2012 licensing is… Read more
Security is one of the most discussed topics for any cloud deployment plans and no organisation would like to compromise on security when they make that ‘final’ decision to move their database to the cloud.
In this blog post we will review how protected are our SQLDatabases within Windows Azure… Read more
Well, that is one impressive dashboard of Audi RS4! It gives huge amount of flexibility for the driver to control the transmission with lot of ease, and get quick view of crucial information.
Windows Azure portal does provide a dashboard for SQLDatabase too!
It will give information regarding space usage,… Read more
In this post we will review some basic DML,DDL capabilities of SQL Database on windows Azure.
This post is in continuation with my earlier 3 posts
One of the most basic capacity considerations involved while planning to move SQL workloads to a virtual environment is to understand the maximum capacity of a single Virtual Machine (VM.
Many times questions arises in mind like “what is the max memory which a VM supports?”
Look at what one… Read more