SQL Saturday #46 - Raleigh
A free one day training event in Raleigh, NC. Come to the first SQL Saturday in this city on Sept 18, 2010
2010-09-13 (first published: 2010-09-02)
1,529 reads
Articles
2010-09-10 (first published: 2008-11-17)
33,008 reads
Identifying and Eliminating the Dreaded Cartesian Product
Cartesian Products usually don't provide useful information and often result in mistakes that can hurt your database developer career. Learn to spot Cartesian Joins and banish them from your SELECT queries forever.
2010-09-10
4,388 reads
SQL Saturday #48 - Columbia
SQL Saturday Columbia, SC gives you a chance to get a full day of free SQL Server information, lectures, and seminars from the experts on the East Coast.
2010-09-10
1,014 reads
Inside the Optimizer: Constructing a Plan - Part 2
How does the query optimizer build an execution plan for your queries? Paul White shows is in part two of a four-part series exploring the internals of query optimization.
2010-09-09
7,828 reads
Webinar: Turn your backups into live databases with SQL Virtual Restore
Find out in this webinar how easy it is with Red Gate's SQL Virtual Restore to mount live, fully functional databases direct from backups – without performing a physical restore. Learn how you can use SQL Virtual Restore to save storage space and time across a wide range of database administration activities.
2010-09-09
1,090 reads
AdvanceTimePolicy and Point Event Streams In StreamInsight.
There are a number of ways to issues CTIs (Current Time Increments) into your StreamInsight streams but a quite useful way is to do it declaratively on your source factory like this
2010-09-09
1,492 reads
An Informal Look at Database Performance
A review on the basic steps to correct a poorly performing query
2010-09-08
12,474 reads
The DIS-Information Principle: A Splitting Headache
You can easily re-factor bad DML code, but if a database design is wrong, you can do little to rescue the problem, even with expert queries. So what constitutes 'wrong RDBMS design? What are these errors that continually crop up? How can you recognise them and fix them? Joe embarks on a new series of articles by identifying a series of bad practices based on the habit of 'splitting' that which shouldn't be split.
2010-09-08
2,767 reads
Early September Free Training from PASS VCs
Hope you got plenty of rest over your Labor Day holiday because the PASS Virtual Chapters have some great free training lined up for you.
2010-09-07
1,105 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers