Microsoft Data Platform – MVP 2017!!!
I’m very pleased and delighted to share that I have been awarded Microsoft Most Valuable Professional (MVP) award 2017. This...
2017-04-14
429 reads
I’m very pleased and delighted to share that I have been awarded Microsoft Most Valuable Professional (MVP) award 2017. This...
2017-04-14
429 reads
DMV: sys.dm_db_stats_histogram (object_id, stats_id)
For a long time, the DBCC SHOW_STATISTICS command was the only way to get information about statistics....
2017-02-22
785 reads
If you are dealing with a SQL Server which got a lot of memory, you may encounter the out of...
2017-02-20
1,264 reads
Recently, I experienced an interesting issue where I found SQL Server wait type PageLatch_UP went up drastically after migration. Let’s...
2017-02-06
486 reads
DMV: sys.dm_server_services
Microsoft SQL Server 2008 R2 SP1 and SQL Server 2012 has a new set of DMVs. One of them...
2017-01-11
337 reads
DMV : sys.dm_os_volume_stats
Being a SQL Server database administrator, you may often receive alerts or asked by Senior DBAs to check, if...
2017-01-09
15,971 reads
As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at...
2017-01-06
2,055 reads
In this blog post. Let us learn about how to retrieve date and time when the SQL Server was installed. To retrieve...
2017-01-04
10,520 reads
HAPPY NEW YEAR 2017!!
I hope you all had a good Christmas and New Year. I always try to review my...
2017-01-01
8,092 reads
In the previous tutorial, we went through how to setup “External Network” to access the internet on Hyper-v client machine....
2016-12-25
2,709 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers