DevWeek is Europe’s leading independent conference for software developers, database professionals and IT architects, and features two dedicated tracks of breakout sessions on SQL Server and related topics, plus optional pre- and post-conference workshops.
Being a DBA demands that you keep up with the latest technology, and conferences are one of the best ways to do that. So, despite the fact that training budgets may be shrinking, I suggest you begin lobbying your manager to attend as many SQL Server events as you can. If you can't get your company to send you to a paid conference, then try to attend one of the free ones, on your own time.
This tip shows you how to find security holes when aliased users are setup in your databases and also that this feature will be deprecated in SQL Server 2008.
If a column is normalized, but the user really wants to see the values as a short comma separated list, how can I write a query that produces the list? Concatenating the values in a column would be pretty easy if SQL Server had a concatenate aggregate function, which it doesn't. What's more, for efficiency sake it's important to write the reporting queries without using cursors.
Trust is a big part of any DBA's job. But it seems that many people in society trust each other less and less all the time. Steve Jones has a few comments on this important subject.
Trust is a big part of any DBA's job. But it seems that many people in society trust each other less and less all the time. Steve Jones has a few comments on this important subject.
Trust is a big part of any DBA's job. But it seems that many people in society trust each other less and less all the time. Steve Jones has a few comments on this important subject.
Phil takes us through one of the best kept secrets of SSMS - Templates. Even for a 'plain-screen' man like Phil, Templates are an excellent tool, and a major reason to use SSMS.
How can we determine the sheet names in our SSIS package and process this variable number of sheets?
New data-profiling tools native to SQL Server 2008 Integration Services such as the Data Profiling task and the Data Profiler Viewer help manage a business intelligence strategy.
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Comments posted to this topic are about the item Finding Motivation
Comments posted to this topic are about the item The Last Binary Value of...
Comments posted to this topic are about the item SQL Art, Part 2: New...
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers