Browse by Tags
» SQL Programming (RSS)
Showing page 2 of 4 (31 total posts)
I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such. But I digress...
Anyway, I pointed out a couple ...
Join Us for 24 Hours of SQL Server Training
(with a special focus on SQL Server 2008 R2)Did I mention that your Cohorts in Crime
(that be me
Ozar) are presenting?!?
The FREE 24 Hours of PASS event is bringing an exceptional
lineup of SQL Server and BI experts to your computer starting at
12:00 GMT (UTC) on May ...
Before I jump onto the Goals and Themeword meme started by my buddy, Thomas LaRock (blog | twitter),
I decided I'd spend a few minutes looking back on both the year 2009.
(From a personal standpoint, the 00's were my most difficult decade
yet. Major problems of every stripe beset me on all sides and with
alarming frequency throughout ...
Please join me for SQL Saturday #21
coming up on Saturday, October 17th. There are over 50 sessions on tap
with great speakers from the area and across the nation. Some of the
notable speakers include: Andy Leonard (blog here)Andy Warren (blog here)Brian Knight (blog here)Buck Woody (blog here)Chad Miller (blog here)Joe Celco (blog ...
Any IT pro with more than a year or two of experience will have
faced the challenges of version control for an application, but what if
you have to implement version control for data?
The most common way to tackle this problem is implementing something
called ''bitemporal data''. Under this method, each row in a table
includes the current ...
One of the fundamentals of loop optimization is that you should move stable operations outside of the loop. What I want to know is - if this is such a fundamental rule, why do so many people break it?!?If you are familiar with other programming languages, then you are probably aware of loop optimization techniques. You should try to put all ...
I like to collect useful database administration queries that leverage the SQL Server 2005 and 2008 DMVs. Heck, I'm still interested in SQL Server 2000 queries too. I thought I'd make my search public so that a) you can share your favorite queries here or great reference queries written by others and publicly posted on the ...
I had the pleasure of speaking with SQL Server MVP, Denis Gobo, about my newest book, SQL in a Nutshell 3rd Edition. In the interview, we discuss the state of database industry, ANSI SQL, and other related questions.
Check out Denis' interview (and his fine blog) at http://tinyurl.com/bs5wea.
There’s been a lot of positive press for LINQ, such as the article about LINQ by Mike Otey at http://www.sqlmag.com/Article/ArticleID/48759/sql_server_48759.html. You can also find lots of glowing reviews and info about LINQ by Troy Magennis at http://blog.aspiring-technology.com/.
I've been trying to figure out exactly how I feel ...
If you've been around a while, you tend to do things the way you first learned how to do them. This can turn you into an ''old timer'' whose oblivious to new and better ways to do things that have appeared in the newer releases of the technology.
Take measuring log space, for example. If I wanted to find out how much log space ...