In this article, Tim Smith goes through a couple of options to automate heartbeat checks against Azure databases. This is useful if you're moved SQL Server databases to Azure and you want to have periodic checks to make sure the databases are responsive.
In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.
In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.
With no end to company hack attacks in sight, will we get new regulation instead?
Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.
Redgate is researching how people deploy their database changes. This is a very quick survey, and there's an opportunity to sign up for a research call in exchange for a $50 Amazon voucher.
This article shows how you can use SQL Server spatial methods, mathematical rules and oscillating patterns to benchmark CPU, IO and Hekaton performance.
The debate over how to change code or solve a problem can create arguments that last for years. Steve Jones notes the idea of limiting debates to five minutes is interesting.
CSS Engineers at Microsoft are reporting more space issues with database systems. Steve Jones has a few comments.
WMI (Windows Management Instrumentation) is the basic way of querying and changing basic information about any windows server, including SQL Server or Exchange Server. It provides a logical structure and representation of systems and services that are hosted on the server and is essential for anyone who is keen to automate routine monitoring and administration work via PowerShell, especially where many servers are involved in the task.
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
WA:08218154393 Jl. Gatot Subroto No.080A, RT.001, Cigobang, Gunungsimping, Kec. Cilacap Tengah, Kabupaten Cilacap, Jawa...
WA:08218154393 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten Cilacap,...
Comments posted to this topic are about the item SSRS Reminded Me of the...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers