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
450 reads
SQL Geek
Read Statistics Histogram using DMV
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
1,008 reads
Out of memory error because of the very low virtual address space – Error 701 – Trace Flag 8075
If you are dealing with a SQL Server which got a lot of memory, you may encounter the out of...
2017-02-20
1,295 reads
After migrating SQL Server from 2005 to higher version, the waits type PAGELATCH_UP increased
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
542 reads
SQL Server Service Information
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
383 reads
Disk Space Monitoring using SQL Server DMV
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
17,942 reads
New String Function – TRIM – in SQL Server vNext
As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at...
2017-01-06
2,080 reads
When was SQL Server installed?
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
13,875 reads
Identifying Blocking Chain in SQL Server
HAPPY NEW YEAR 2017!!
I hope you all had a good Christmas and New Year. I always try to review my...
2017-01-01
13,024 reads
Configure Internal and Private Networking for Hyper-V Virtual Machines
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,904 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers