Quick tip: format source code in html
I run a technical blog, so it is necessary to put code in almost every post. Most of the GUIs...
2018-04-25
99 reads
SQL Guatemala
Configure Min and Max memory in Reporting Services
As any of the available SQL Server services, Reporting Services will use all of the server memory if needed, in...
2018-04-23
15,247 reads
PowerShell script repository - SQL Server
A simple get-help output
PowerShell is a .Net based command line tool designed for automation.
It is recommended to script repetitive task...
2018-03-21
309 reads
Reporting services error: User XXXX does not have required permissions
If you encounter the following error trying to access reporting services:
User XXXX does not have required permissions. Verify that sufficient...
2018-03-02
265 reads
Performance Basics: Key lookup operator and query optimization
One of the most basic things to improve performance in our queries is using indexes, but this doesn't mean that...
2018-02-14
553 reads
Considerations for dealing with big databases
Stress everywhere, user wants everything "Para ayer"Photo by Bernard Goldbach
If you are like me, and have SQL Server instances with...
2018-02-01
588 reads
Meltdown and Spectre exploits, they can affect your SQL Server instances
A bug was recently discovered on almost every processor made on the last 10 years, and it seems that almost...
2018-01-05
59 reads
Happy new year 2018 to all!
From SQL Guatemala, we wish you a happy new year 2018.
We hope this new year brings you joy and zero:...
2017-12-30
327 reads
SQL Vulnerability Assessment
A very interesting feature was recently added to SQL Server Management Studio 17.4 (SSMS): The new SQL Vulnerability Assessment.
What is...
2017-12-12
147 reads
How to check advanced options in SQL Server?
To check the available advanced options configured at instance level in SQL Server, you need to use the sp_configure system...
2017-11-24
45,331 reads
Blogs
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Forums
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
BIT_COUNT() III
Comments posted to this topic are about the item BIT_COUNT() III
The Mythical Bus Accident
Comments posted to this topic are about the item The Mythical Bus Accident
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers