Security: Create and view Audit Logs
It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this...
2018-04-30
5,050 reads
It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this...
2018-04-30
5,050 reads
I run a technical blog, so it is necessary to put code in almost every post. Most of the GUIs...
2018-04-25
79 reads
As any of the available SQL Server services, Reporting Services will use all of the server memory if needed, in...
2018-04-23
12,603 reads
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
284 reads
If you encounter the following error trying to access reporting services:
User XXXX does not have required permissions. Verify that sufficient...
2018-03-02
149 reads
One of the most basic things to improve performance in our queries is using indexes, but this doesn't mean that...
2018-02-14
504 reads
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
535 reads
A bug was recently discovered on almost every processor made on the last 10 years, and it seems that almost...
2018-01-05
48 reads
From SQL Guatemala, we wish you a happy new year 2018.
We hope this new year brings you joy and zero:...
2017-12-30
313 reads
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
121 reads
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers