|
|
|
|
Got a SQL Server question that needs answering? SQLblog now has a SQL Server forum that can be found at http://sqlblog.com/forums/57/ShowForum.aspx.
Latest Blog Posts
-
|
There are a number of key books that I've missed reading over the years, in areas that interest me. Recently, I've been fixing that. One that is always discussed is The Microsoft Data Warehouse Toolkit by Joy Mundy and Warren Thornthwaite from the Kimball...
|
-
|
There is a patch available for four elevation of privilege vulnerabilities recently discovered in SQL Server. From http://www.microsoft.com/technet/security/bulletin/ms08-Jul.mspx : This security update resolves four privately disclosed vulnerabilities....
|
-
|
I was just rereading a blog post by Euan Garden about SQL Server's history and he refers to the fact that you can read a chapter about the history in the Inside SQL Server books. In the rewrite of the book for SQL Server 2005, when we split the book into...
|
-
|
I've had a lot of "fun" working the with new spatial types in SQL Server 2008. Fun like your first root canal sometimes, fun like a great first date other times. One of the "root canal moments" for me has been around Geographic Markup Language (GML) support....
|
-
|
(See my initial blog post for general information about this proc.) I just updated sp_indexinfo a bit: I added the schema name as a new column in the output of the first resultset. I added an optional second resultset with missing index information. This...
|
-
|
Well I was called out by Tibor Karaszi , so here goes: How old were you when you first started programming? I'd say I was about 19 when I started. I remember in 1976 that I was at University of Queensland. I was doing an honours degree in physics and...
|
-
|
The official list of supported operating systems, service packs, and numbers of virtual processors can be found here: http://support.microsoft.com/kb/954958/en-us . If you are willing to venture into unsupported territory, you might find some surprises....
|
-
|
Hi everybody, I am new to SQLBlog.com so I thought I would blog a little about who I am. My name is Eric Johnson, not the guitar player, though I would like his money :) I am the co-founder of Consortio Services ( www.consortioservices.com ), and the...
|
-
|
For those of you who connect to database servers where you are not in full control over all databases, or where some of your databases are ever offline (or auto-closed), the new version of Management Studio that is shipping with SQL Server 2008 is going...
|
-
|
We all know them, they're usually developers or network admins who show some abilities when database problems arise, so they're "elected" to the role of DBA, whether they want it or not. They often don't have the necessary training or insight into the...
|
-
|
I am. I find myself endlessly hunting for index information when working against the various SQL Servers I come in contact with. And, sure, the information is there. You just need to go and get it. This generally means that I start with sp_helpindex....
|
-
|
Our team at SolidQ have been working on a number of whitepapers for SQL Server 2008. On of the first of these out the door is Itzik Ben-Gan's new paper on the T-SQL enhancements. It's great reading and can be found at: http://msdn.microsoft.com/en-gb/library/cc721270(SQL.100).aspx...
|
-
|
It’s well known that bookmark lookup (aka key lookup in case of a clustered index) is not cheap, especially when it comes to retrieving a lot of data. So I’m not going to rehash the pros and cons of bookmark lookup or why bookmark lookup is expensive....
|
-
|
I was called out by my friend Kalen Delaney on the Software Development Meme (something I've never heard about before, I had to look it up on the Internet ;-) ). Here goes: How old were you when you first started programming? I can't say for sure, I don't...
|
-
|
Whenever I am asked “What is the single most important advice to write efficient MDX”, I always give same answer: The simpler MDX you write – typically the better performance you will get. The reasoning behind this is straightforward: If MDX is simple,...
|
-
|
In the next series of posts, I'll focus on SQL Server I/O, revisiting some common issues and taking a closer look at some others. In each post and as always, I'll make the case with specific data points from my tests. For the first two posts in this series,...
|
-
|
A lot of people sent me emails asking for a way to get ahold of Quest Software's new DMV poster. The poster shows all of the major DMVs in SQL Server 2005/2008, what they're used for, and how to query them. You can get the poster (for free, of course)...
|
-
|
Microsoft has publicly stated that SQL Server 2008 will RTM in Q3. It is Quarter 3 now. Where is it? :-) I'm sure that the final touches will now get taken care of now that Bill Gates is no longer a full-time MSFT employee. I'm sure that his "short-timer"...
|
-
|
I asked for some names of people who you would like to see interviewed here at Sqlblog and Jamie Thomson's name popped up a couple of times. I contacted Jamie and he was kind enough to take time out from his busy schedule to answer these questions. So,...
|
-
|
I was just tagged by Andy Leonard, and truth to tell, I don't read Andy's blog all that often because he talks about really developer oriented stuff, which is a little outside my focus area now. But I was intrigued by the concept of a techblog meme, which...
|
|
|
|
|
|