Bug in SSMS V17.4
If you are using SSMS V17.4 as I am
You may encounter a weird error. This can be repeated as follows:
Open...
2018-02-06
387 reads
If you are using SSMS V17.4 as I am
You may encounter a weird error. This can be repeated as follows:
Open...
2018-02-06
387 reads
With technology expanding in both complexity and quantity, the task to name each component and functions of a technology product...
2018-01-24 (first published: 2018-01-15)
1,640 reads
It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR...
2017-02-22 (first published: 2017-02-21)
4,880 reads
It is an open secret that in SQL Server, we can “create a system object” by using an undocumented stored...
2017-02-17
618 reads
I am studying the latest R integration with SQL Server 2016, and I believe I encounter a bug when using...
2017-01-26 (first published: 2017-01-19)
1,401 reads
Every year, financial advisors will recommend their clients to take a review of their investment portfolio and make necessary changes...
2017-01-23
679 reads
After 10+ years of a dedicated DBA, for the past 17 months, I have purposely chosen to work as a...
2016-12-01 (first published: 2016-11-28)
1,858 reads
In Canada and USA, when people apply for a credit card or a loan/mortgage, the lending institutions will always do...
2016-06-08 (first published: 2016-06-01)
1,982 reads
With SQL Server 2016 to be officially released this year, I want to make a wish list for the features...
2016-01-15 (first published: 2016-01-10)
1,624 reads
With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered...
2015-10-25
1,875 reads
By Steve Jones
This series looks at the Advent of Code challenges. I started the Advent of...
By Kevin3NF
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...
Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can...
This is kinda hard to explain, maybe I can make sense of it. So...
Dear friends, Please, could you give me some ideas, how to implement SELECT count(*)...