TSQL Challenge 35 - Find the total number of 'Full Attendees' in 24HOP
This challenge has a (fake) reference to the 24 Hours of PASS event and your task is to count the number of attendees who watched the complete presentation of each speaker.
SQL Server CRUD-Generation from System Views
If you are not keen on repetitive typing, you can still rapidly produce production-quality documented code by planning ahead and using Extended properties, and system views. Phil Factor explains, with some Scary SQL
Missing Indexes in SQL Server 2005
Determining which columns to index in a table used to be a very time consuming process that was as much art as science. New author Ranga Narasimhan brings us an article that shows how SQL Server 2005 makes this much easier.
ROWE
ROWE stands for a Results Oriented Work Environment. This Friday Steve Jones asks if you'd like to work in one.
For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin
In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...
Oracle to SQL Server, Crossing the Great Divide, Part 3
We soon learn, in SQL Server, that heaps are a bad thing, without necessarily understanding how or why. Jonathan Lewis is an Oracle expert who doesn't like to take such strictures for granted, especially when they don't apply to Oracle. Jonathan discovers much about how SQL Server places data, and concludes from his experiments that heaps perform badly in SQL Server because you cannot specify a fill factor for them.
Self-Service vs. Managed BI
Is self service BI a good idea? Some people think so, others don't. Steve Jones talks about one of the issues and why it might actually not be a problem.
Configuring Alerts for Policy-Based Management
How can I receive notifications when the policies I have implemented have been violated so I don't have to manually look at each server?
Becoming Highly Productive
Today we have a guest editorial from Andy Warren. You can get more productive, but are you being productive at the tasks that you should be working on? See what Andy Warren has to say.
SQL CLR Data Types and Performance
Using SqlTypes can have a significant impact on the performance of your SQL CLR implementations. Is it for the better? Read this article to find out.
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers