Grouping Sets in SQL Server 2008
This article shows how to use the GROUPING SETS feature in SQL Server 2008
Mini-Me
This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.
Mini-Me
This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.
Mini-Me
This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.
Creating a Basic Policy in SSMS - SQL School Video
In SQL Server 2008, we have a new way of enforcing rules on our servers. This video has MVP Brian Knight showing us how to create a basic policy in Policy Based Management.
Go Open
Is Open Source something you should examine with the economy diving down? Steve Jones talks about a few of the issues.
How to setup and use a SQL Server alias
I have an application that has a specified database connection that I either can't or don't want to change. However, I need to move the database to a new server. How can I do this easily without breaking other things that maybe using this connection and/or database?
SSAS Cache Warming Using SSIS
Having your users walk into a cold cache on a morning is something that will cause them to have slower running queries initially. Cache warming takes care of a lot of that by executing typical queries against the newly processed cube and thereby building the cache ready for your users
Trust But Verify
As data professionals we need to be sure that we can present back the data we receive. Perhaps other people should embrace this mantra in other lines of work.
Trust But Verify
As data professionals we need to be sure that we can present back the data we receive. Perhaps other people should embrace this mantra in other lines of work.
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers