Finding a job!
I’ve been told over the years that I’m pretty good at finding jobs. I mean in the last 25 years...
2014-09-04 (first published: 2014-08-27)
7,704 reads
Blog Posts
How to Start SQL Server in Single User Mode ?
Sometime, We caught in a situation where we need to run SQL server in single user mode. Issues like Master DB restore, Sysadmin locked out etc. Steps to start...
2014-09-04
13 reads
Pausing an MSSQL Instance
I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop...
2014-09-04
3,839 reads
Refreshing Availability Group Database with PowerShell
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh...
2014-09-04
1,625 reads
The Art of Performance Tuning
Performance tuning often gets called an art as people feel that a certain knack or innate talent comes into play....
2014-09-04 (first published: 2014-08-28)
8,787 reads
Top ADO.Net Interview and General FAQs
1. What is ADO.Net?
ADO.Net is set of components (classes) that are used to access data based on disconnected dataset and XML.It...
2014-09-04
1,272 reads
Why You Should Go to SQL Saturday
SQL Sat Puerto RicoHello Dear Reader! Soon SQL Saturday #318 in Orlando FL will be here. The SQL Community does...
2014-09-04
872 reads
A Page-Splitting Headache - Page Split Mini-Series
Page splits are a normal occurring process in an OLTP system. However, too many page splits can cause performance issues...
2014-09-03 (first published: 2013-07-08)
9,729 reads
Analysis Services Dynamic Security
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username...
2014-09-03
3,042 reads
Analysis Services Dynamic Security
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username...
2014-09-03
783 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers