|
|
-
|
|
Technology,networking,knowledge sharing under one roof and that too for 3 consecutive days !!! Wow,thats TechEd for you.
[Picture courtesy - http://yodigo-contrablog.blogspot.com]
TechEd India 2012 gave me a fabulous ride this time.Even though I couldn...
|
|
-
|
|
Couple of days back Microsoft released BPA for SQL 2012.There are no major changes which I could catch within the tool and the whole install,scanning looked similar to the earlier version.SQL Server 2012 Best Practices Analyzer will offer scanning of both ...
|
|
-
|
|
Today I was querying sys.databases system view in SQL 2012 and was curious to find one column named target_recovery_time_in_seconds.I was pretty sure that this column was not available before 2012.
I decided to learn more about this,and a quick search on...
|
|
-
|
|
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 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...
|
|
-
|
|
Have you ever faced a situation where in you had to double check what all features you deployed for your SQL Server environment ? Oh! did I selected Full-Text search feature during installation?
There are many number of ways you can double check the featur...
|
|
-
|
|
Policy Based Management or PBM was introduced in SQL Server 2008 initially.This feature will help Database Administrators to create policies and ensure that his/her environment is in compliance with that policy.
Lets take a simple example of recovery model...
|
|
-
|
|
Last week I was pretty much focusing on setting a lab environment to test SQL 2012 Availability Groups and Failover Cluster Instances.
I had to setup 3 VM’s to play around and out of that one will be a domain controller.
Once all the VM’s were ...
|
|
-
|
|
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
SQLSailor is exploring(Part1) – Creating my first SQL Database on Windows Azure
SQLSailor is exploring(Part 2...
|
|
-
|
|
“ReFS”, this term was absolutely new to me when I was reading this white paper from Microsoft ‘Storage Windows Server 2012′.
ReFS is the next gen file system from Microsoft, and available in Windows Server 2012.
Here are some of the...
|
|