For the preparation of my upcoming talk about SQL Server 2012 Master Data Services on the Microsoft Business Analytics Day (hosted by my company element61), I read the book Master Data Services 2nd edition by Tyler Graham. I had almost no prior experience with MDS up to this point (I very quickly glanced over it […]
Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.
Browsing "sql server 2012"
Eric Ligman has posted a nice collection of ebooks available in pdf, epub and mobi formats. The books cover Office, Office 365, SharePoint, SQL Server, System Center, Visual Studio, Web Development, Windows, Windows Azure, and Windows Server
In this week’s puzzle we are going to try to figure out how many uppercase, how many lowercase characters are in a column, we are also interested in how many are neither uppercase or lowercase
Here is the table and the data
CREATE TABLE Puzzle…
Just got a question on my A first look at sequences in SQL Server Denali post.
The question is the following: How can you add a new column to existing table (already populated) and make it a sequence column?
Let’s take a look. First create this ve…
Time for this week’s puzzle/teaser. I want to return the results in ascending order but without using ORDER BY
If you run this code
CREATE TABLE Puzzle
(Col1 varchar(20) NOT NULL PRIMARY KEY CLUSTERED,
Col2 varchar(20) NOT NULL UNIQUE…
In last week’s puzzle SQL Puzzle: RIGHT without using the RIGHT function we looked at how to do a RIGHT function without using the RIGHT function. Today we are going to find out how many columns are even in a row.
Before starting I want you to be aw…
I haven’t done a puzzle for a long time so I figured let’s do a simple one. Return the right 6 characters of the column but without using the RIGHT function.
Here is what the table looks like
CREATE TABLE #Puzzle(SomeCol CHAR(7))
Today I was checking an older server and decided to run sp_helpdb. On a bunch of databases I noticed that the owner was ~~UNKNOWN~~. The only reason I noticed this was when I tried to look at a specific database which is mirrored. I was greeted with thi…
I had to change the account that some SQL Server boxes were using to run the SQL Server services. After I changed the account on one machine from DomainNameUser to DomainNameNewUser SQL Server wouldn’t start up
In the error log I saw the following…
If you look at the sys.sysobjects view, you will see an xtype column listed
Object type. Can be one of the following object types:
AF = Aggregate function (CLR)
C = CHECK constraint
D = Default or DEFAULT constraint
F = FOREIGN KEY constraint