Mass Backup All Sessions
Migrating Extended Event Sessions from one server to another should be a simple task. So simple, one would think there was no need to give it a second thought,...
2019-06-12 (first published: 2019-05-23)
203 reads
Jason Brimhall
Note to Self
Not only should you pay respect to those giving of their time, but you should spend a little time to also give back to the community. I will say...
2019-06-11
11 reads
Note to Self
Not only should you pay respect to those giving of their time, but you should spend a little time to also give back to the community. I will say...
2019-06-11
Note to Self
Not only should you pay respect to those giving of their time, but you should spend a little time to also give back to the community. I will say...
2019-06-11
1 reads
Easy Open Event Log Files
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to better service the needs of the developers when the...
2019-06-07
Easy Open Event Log Files
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to better service the needs of the developers when the...
2019-06-07
3 reads
Easy Open Event Log Files
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to better service the needs of the developers when the...
2019-06-07
242 reads
Implicit Conversion Insights with XE
Seldom does a DBA have the opportunity to get out in front of infrequent or random errors such as implicit conversions. More often than not, it is the privilege...
2019-06-05
7 reads
Implicit Conversion Insights with XE
Seldom does a DBA have the opportunity to get out in front of infrequent or random errors such as implicit conversions. More often than not, it is the privilege...
2019-06-05
4 reads
Implicit Conversion Fail
Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don't quite follow decent practices when designing the...
2019-05-31
3 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers