Management Studio Drag & Drop Column Names
Continuing on my recent trend of Management Studio tips, here is another that could save you a few minutes. In today’s scenario, we need to write a select statement...
2020-07-07
4 reads
Patrick
- Twitter: @patrickkeisler
- Website: https://www.patrickkeisler.com
- LinkedIn: https://www.linkedin.com/in/patrickkeisler/
SQL Server Audit Recipe – xp_cmdshell
This article assumes you already have a basic understanding of SQL Server Audit, but if not, use this link to catch...
2018-07-17
161 reads
SQL Server Morning Health Checks
Every now and again as a Microsoft PFE, you get a chance to make a big difference for a customer....
2018-01-08 (first published: 2018-01-02)
2,587 reads
Create a Whitelist for SQL Server - UPDATED!!!
A while back, I posted an article about creating a WhiteList for access to SQL Server. Since then I have...
2017-05-16
3,763 reads
Dear McAfee, Why are you destroying my buffer pool?
For the past few months, one my customers had been trying to diagnose an issue with SQL Server paging out...
2017-05-02
1,235 reads
Blob Auditing for Azure SQL Database
In February 2017, Microsoft announced the general availability of Blob Auditing for Azure SQL Database. While auditing features were available...
2017-04-18
622 reads
AzureRM Module Version
When working with the AzureRM PowerShell module, remember the module is constantly being updated to take advantage of new features...
2017-04-13
348 reads
A Goal of Speaking at PASS Summit
Everyone has goals or at least they should have goals. As a young professional out of college, I had plenty...
2016-09-26
559 reads
SQLPSX is Finally Getting Updated
The most current code is now on Github, with the Codeplex version being depreciated. You can read all about the...
2016-08-16
511 reads
TSQL Tuesday #79 -SQL Server 2016 Launch Discovery Day (aka Hackathon)
The host for T-SQL Tuesday #79 is Michael J. Swart (b|t), and his topic of choice is to write about...
2016-06-14
622 reads
Blogs
Get Configuration Change History From the SQL Server Error Logs
By SQLPals
Get Configuration Change History From the SQL Server Error Logs There...
A NEW’er Solution For An Old Problem: How To Gain Access To SQL Server When No DBA Around
By SQLPals
How To Gain Access To SQL Server When No DBA ...
Forums
Managing some particular dimensions in a data warehouse based on medical records
Hi, I need to design a data warehouse solution to manage medical records about...
Gentlest of Reminders, Don't Stop Learning
Comments posted to this topic are about the item Gentlest of Reminders, Don't Stop...
table with varcahar(max)
Gurus, there is a table which is very slow to query , it has...
Ask SSC