Understanding the concept of SQL Server Failover Cluster
Before getting hands on experience in SQL server on failover cluster , I used to read many article about failover clustering. Unfortunately...
2012-03-14
17,300 reads
PracticalSQLDba
Memory configuration in SQL server and break up of memory utilized by SQL server
In this post I would like to explain memory configuration option and memory utilization pattern in SQL server.I have seen...
2012-03-11
3,722 reads
How to log off remote desktop users from a remote machine ?
When you try to log on to a remote server on emergency to perform some task , it may throw an...
2012-03-06
8,178 reads
Resource Governor Configuration
Resource Governor(RG) is a technology which introduced in SQL server 2008 to manage the CPU and Memory resource that a incoming session can...
2012-03-04
4,557 reads
How to setup a task to delete the old backup files or log files from the server ?
Cleaning up the servers disks on daily basis is very important task for smooth functioning of servers.We have seen many...
2012-02-27
1,391 reads
How to remove new line character from string using SQL ?
In a varchar column some of the entries were showing space in the left side and even after using the...
2012-02-26
9,133 reads
Blogs
A New Word: Opia
By Steve Jones
opia – n. the ambiguous intensity of eye contact The entry for this says...
Friday Flyway Tips: Searching a Migration
By Steve Jones
This was actually a cool tip I saw internally from one of the product...
Build Recovery into the Design
By Brian Kelley
It's like disaster recovery (and business continuity) planning is the end-of-term research paper that...
Forums
Serverless Gets Faster
Comments posted to this topic are about the item Serverless Gets Faster
sqlclient data provider .net provider connection
I have a task to check the connection managers as part of ssis integration...
Question of the Day
Statistics Histograms
I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?
See possible answers