(Pinal Dave) I know I have been fortunate to write back-to-back on topics around SQL Server. I get a number of you do take time in writing down to me over emails, comments and even sometimes over skype pings. I see every such mail as an opportunity to learn something from you for sure.
Tag: sql server
Look at Blocked Process Reports Collected With Extended Events
(Michael J. Swart) I just met a friend at a SQL Saturday who let me know that he recognizes my name because it was attached to a project I wrote five years ago. The “Blocked Process Report Viewer”. I was impressed.
Well that’s just neat: Row Level Security, new in SQL Server 2016
(Jen McCown) SQL Server 2016 offers Row Level Security, which sounds awfully cool. It’s apparently been available in Azure for a while, but the on-prem version is getting it, now.
Powershell script to create multiple SQL Server Connections
(Kenneth Fisher) As with most of these types of things, I had a need. I want to show how using sys.dm_exec_[requests/sessions/connections] is better than sp_who. Particularly when you have a large number of connections.
SQL Server Backups and Transaction Log Questions
(Sergey Gigoyan) In this tip we will continue to investigate some questions related to SQL Server backup and restore. In the previous tip (Solve Common SQL Server Restore Issues) we discussed questions about the transaction log chain, restoring from COPY_ONLY backups and backup to ‘NUL’ disk.
How to make SSMS beep when a query is done?
(Denny Cherry) The other day I’m sitting at my computer, and this comes across Twitter.
What is the benefit to Microsoft SQL Server Express on Azure?
(Robert Sheldon) From the customer’s point of view, having Microsoft SQL Server Express on Azure could have a number of benefits. Because it’s free, customers that have already jumped aboard the Azure train have one more tool at their disposal for developing and testing apps, as well as for implemen
Issue Tracking for Databases
(Matthew Skelton) Any database development project will be hard to manage without a system for reporting bugs in the code, anomalies and incidents from live environments, and for keeping track of new features.
New in-built Table-Valued Function STRING_SPLIT() in SQL Server 2016 – to split strings
(Manoj Pandey) Till now it was bit tricky to split a Sentence or CSV String to multiple values or rows, and we used different logic to do the same.
Shrink a log file…AUTOMATICALLY?
(Jen McCown) Today let’s talk about shrinking log files, and Minion Backup – still totally & forever free – and how they go together.
