|
|
|
|
Nearly any SQL topic presented at times in a slightly eclectic manner.
Browse by Tags
All Tags » SQL Server (RSS)
-
To whoever manages SQL Server DBAs\developers\BI specialists: Yesterday afternoon at PASS I stuck my head into a presentation Kevin Kline was giving on end-to-end performance monitoring/tuning. He had reached the point where he was starting to talk about Read More...
|
-
Andy isn't the only one that can ask a survey question. This is something I really curious about because many of the answers or recommendations or rants in blogs are not universably applicable to every database - small databases must sometimes be treated Read More...
|
-
At PASS this year, Adam Machanic and Peter DeBetta gave a great session presenting things as sort of "anti-patterns". They would have slides that have would say things like "Naming standards are irrelevant" or "always use heaps". It was a blast. The audience Read More...
|
-
I've run into this problem again and again. Sometimes I've had luck in convince clients that if a 3rd-party application is hard-coded to use SA is shouldn't even be considered. Sometimes not. With all of the issues that have come up with the SA account Read More...
|
-
I read a very interesting post on Kimberly Tripp's blog which was about indexing, but she had a very interesting set of requirements for good indexing that I think apply to everything when designing, tuning, backing up, etc., any database. What strikes Read More...
|
-
I had a great discussion while teaching a class on Reporting Services today, discussing the basics of report design (yes, I make them consider basic principles of report design before I start talking about the technical details - I'm a stickler that way). Read More...
|
-
So I generally speak at PASS every year. Unless I've offended the powers that be, I will again. So, I have an open question to colleagues and readers and those that have come to my sessions - what would you like to know more about? Perhaps everyone could Read More...
|
-
In my last post on filegroups (it seems like ages ago), I argued that separating tables and their non-clustered indexes between two different filegroups, with each filegroup on a separate I/O path can improve performance. That article was met with skepticism. Read More...
|
-
In my previous post on filegroups, I tried to make the case that using filegroups (please everyone tell me you use other filegroups than PRIMARY...) can improve database performance. I received a number of comments challenging that notion, which personally Read More...
|
-
I recently saw a post on one of the MCT forums asking which conference should be attended - TechEd IT Pro, TechEd Dev or PASS when it comes to SQL education. I posted a reply there favoring TechEd (either). I need to defend that a bit better. One reply Read More...
|
-
It never fails to surprise me how rarely filegroups are leveraged in client installations. I'm also surprised at how many SQL Server DBAs are new to the concept of filegroups whenever I teach or give a presentation that includes them. For many of you, Read More...
|
-
In my previous post on NULLs I discussed (rather replied to Hugo Kornelis) some more academic concepts and definitions when it comes to NULL. It is very sad for me to admit that, while interesting to me and many others, that sort of discussion is all Read More...
|
-
Since I had a post on 5 things a DBA should know, I thought I'd follow-up with a quick post about what *I* think any developer should know... 1) Always prefix object names - I can't stress this enough. Even if you have no schemas in place (SQL 2005 schemas, Read More...
|
-
..."hey, what's that spot on my hand?" OK, I put in shameless plugs, but that got me thinking about topics that every DBA should really, really understand. I'm talking a Kalen level of understand (Geeks unite!). I won't be explaining all of these things Read More...
|
-
Strange title, yes. After reading Hugo Kornelis ' excellent post on NULLs , I found myself getting very little sleep as I pondered the points he made. If you haven't already read it, do so, now prefereably. The two main points he brought out were (correct Read More...
|
|
|
|
|
|