Cleveland Rocks! (and does SQL Server)
My first flight of 2014 will be to Cleveland to run a SQL in the City seminar and then speak...
2014-01-15
841 reads
Should You Run For the PASS Board? How Do You Decide?
Here are some of the questions I ask when someone is thinking about running for the Board:
Are you eligible? Read...
2014-01-15
547 reads
sp_SrvPermissions & sp_DBPermissions V4.0
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2014-01-15
907 reads
Restore Master From Backup
There are a few posts running around talking about restoring master from backup. Thomas LaRock has a fantastic "How To:...
2014-01-15
625 reads
Not Dead Yet - Text and NText in SQL 2014
I was recently approached by a client who was running SQL Server 2008 with some databases in SQL 2000 compatibility...
2014-01-15
1,155 reads
PASS BI/DW Virtual Chapter–Analysis Services Attributes and Hierarchies
Please join the PASS BI/DW VC today January 15th at 7PM Central for a presentation on Attributes and Hierarchies in...
2014-01-15
625 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.8: PMML Hell
By Steve Bolton
…………In A Rickety Stairway to SQL Server Data Mining, Part 14.3: Debugging and Deployment, we passed the apex...
2014-01-15
1,609 reads
SQL Server Filtered Index Performance
Filtered Index – Database Performance
SQL Server 2012 includes filtered indexes and is a great feature for Business Intelligence and Reporting databases. ...
2014-01-15
1,001 reads
T-SQL Tuesday #050: Automating Database Restores
Here it is time for the party of the month for the SQL Server acolytes and I was running a bit behind. Why? Well, that was due in part...
2014-01-14
4 reads
T-SQL Tuesday #050: Automating Database Restores
Here it is time for the party of the month for the SQL Server acolytes and I was running a...
2014-01-14
694 reads
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers