Last Weeks Top “Reading” Links #34
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-27
537 reads
StrateSQL
Security Questions: Difference between sysadmin and CONTROL SERVER Permission
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-27
856 reads
Reblog: May 17 to May 23
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-05-24
482 reads
Index Analysis May Update
Seems I managed to make it through all of April without an update to the index analysis stored procedure. It...
2013-05-22
574 reads
Security Questions: Grant Permissions to All Stored Procedures
As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-22
703 reads
SQL Server Security Webcast Questions – Series Introduction
Earlier this month, I presented an Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s. A video...
2013-05-21
708 reads
Last Weeks Top “Reading” Links #33
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-20
616 reads
Get Just The Tools: SSMS Download
Ever jump on a machine to connect to a SQL Server and find out… whoops! No tools. For some reason,...
2013-05-15
934 reads
Last Weeks Top “Reading” Links #32
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-13
657 reads
Security Questions: What permissions are required to create temporary tables?
As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-12
687 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Can/Can't Do/Don't
Comments posted to this topic are about the item Can/Can't Do/Don't
Strange String Splits
Comments posted to this topic are about the item Strange String Splits
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers