Statistics on UNIQUEIDENTIFIER columns
During the SQLRally conference in Copenhagen/Denmark, Brent Ozar (Blog, Twitter) and I had a very interesting conversation regarding Statistics on...
2015-03-16
1,056 reads
Blog Posts
The Demo Setup–Attaching Databases with Powershell
I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases.
TL;DR I have a...
2015-03-16
4,575 reads
There are #temp tables and then there are ##temp tables.
Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly...
2015-03-16
669 reads
Date Range Challenge in sql
Hi Folks,
When you work in a offshore - onsite setup in IT industry and if you are fortunate 🙂 to be a...
2015-03-15
500 reads
Data Size – LEN() vs DATALENGTH() - WaterOx Consulting
Reading Time: 3 minutes No. It isn’t just the way you use your data that...
The post Data Size – LEN() vs...
2015-03-13 (first published: 2015-03-04)
7,120 reads
Friend of Redgate 2015
Today I am excited to announce that I have been accepted into the Friends of Redgate program for 2015. The program targets influential people in their respective technical communities...
2015-03-13
4 reads
Friend of Redgate 2015
Today I am excited to announce that I have been accepted into the Friends of Redgate program for 2015. The...
2015-03-13
397 reads
How to Replace Multiple Strings in a File using PowerShell
Replace the Data Source and Initial Catalog values of WebConfig.XML
Content of XML file
<Configuration ConfiguredType=”Property” Path=”\Package.Connections[ConnStaging].Properties[ConnectionString]” ValueType=”String”>
<ConfiguredValue>Data Source=localhost;Initial Catalog=Stage;Integrated Security=SSPI; Connection Timeout = 10</ConfiguredValue>
</Configuration>
PARAM(
[String]$DatabaseName='DCTarget',
[String]$XML='c:\webconfig.XML',
[String]$DatabaseServer='DataCenterDB01')[string]$db...
2015-03-13
15,508 reads
My First Ever SQL Saturday Pre-Con
Like most people I have a bucket list of things to do before I depart for other things. However I...
2015-03-13
796 reads
Speaker of the Month: February & March 2015
It’s not a question of scheduling. I just haven’t been to lots of community events in the last several months...
2015-03-13
573 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers