March 2014 – SQL Server Monthly Maintenance Checklist
image source
Make sure you start the month right by taking the time to make certain your SQL Server environment is...
2014-03-03
1,501 reads
Blog Posts
Nontechnical Post – Omaha Film Festival
My wife, Molly, is one of the smartest (non-technical) people I know. Although she has learned a lot about what...
2014-03-03
876 reads
Pocket’s Most Popular
I use Pocket for saving some stuff. It works well from Feedly when I see something I know I’ll want...
2014-03-03
708 reads
Powershell in a Month – Day 19 – I/O
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in...
2014-03-03
1,197 reads
SQL Named Instance – Static Port Overrides with SQL Browser
I ran across an issue that I haven’t seen since SQL 2000 and had almost forgotten about. Let’s do a...
2014-03-03
1,266 reads
SQL Server Quickie #11 – Non Clustered Indexes
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-03
435 reads
SSRS Top N and Bottom N reporting with Duplicates
Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did...
2014-03-03
1,219 reads
Suggestion for SQL Prompt and SQL Test (Red-Gate)
Recently I moved my job on ALM topics, focusing on Source Control Management and Testing, in order to reach Continuous...
2014-03-03
525 reads
Upcoming Conferences: SQLSaturdays in Denmark and Portugal. – Presenting In-Memory OLTP Deep-Dive for Administrators
(de)
Im März und April finden 2 europäischen SQLSaturdays statt, die Potential zu einem Geheimtipp haben:
Am 29. März in Kopenhagen, Dänemark
...
2014-03-03
823 reads
Using SQLFiddle
SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one...
2014-03-03
3,065 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