Getting More Hardware Information from SQL Server Denali DMV Queries
As I recently discussed, I often hear from database professionals who are not allowed to access their database servers directly....
2011-04-08
1,487 reads
Blogs
Am I a sysadmin? (or other SQL Server role)
How do you check if you are a sysadmin? It’s fairly easy to do in Management Studio. You can go...
2011-04-08
2,355 reads
Developing with SQL Server: Three ways to get at data
Getting at data within a .NET application can be straightforward using built in controls or much more complex through connections,...
2011-04-07
2,075 reads
SQL Validation Functions - 4 Cool UDF's to have handy
Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...
2011-04-07
12,319 reads
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with...
2011-04-06
3,375 reads
Change SQL Startup Parameters with PowerShell
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
2011-04-05
1,493 reads
The DBAs Guide to Expectation Management
Your customers expectations are their primary measure of your success. How well are you managing them?
You’re reading The DBAs Guide...
2011-04-04
2,065 reads
Maaaaaagic Tables!!!
I had an interview earlier this week. An interview for a SQL developer position. It went fine. But. Question number X...
2011-03-30
4,648 reads
The Mystery Of The Slow Last Row
Things Go South
Recently I was troubleshooting a piece of software that archives data out of a very active import table....
2011-03-29
2,259 reads
Statistics, row estimations and the ascending date column
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
2011-03-28
1,643 reads
Blogs
Updates from Coping Tips
By Steve Jones
I’ve written a lot of coping tips now. Over two years worth (Mon-Fri) since...
What I’ve learned in my first 100 days with a consulting group
By DesertDBA
In case you don’t follow me on LinkedIn or Twitter, your humble host joined...
Power BI as a enterprise data warehouse solution?
By James Serra
With Power BI continuing to get many great new features, including the latest in...
Forums
Last Cube Refresh Showing Wrong Time
Hi I have a tabular model and have been asked to retrieve the last...
Working with T-SQL function AVG ()
Comments posted to this topic are about the item Working with T-SQL function AVG...
The Useful Cloud Tags
Comments posted to this topic are about the item The Useful Cloud Tags
Ask SSC