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
784 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,965 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,505 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,078 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,707 reads
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers