Power Query load settings
One point of confusion I see with Power Query is some people believe Power Query adheres to the Excel limit...
2013-12-23
1,439 reads
Quick SQL Prompt Tip – SSF
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2013-12-23
2,104 reads
SSMS Shortcuts and more
I went and voted for #tribalawards and when I was finished they offer you links to 6 different free PDFs....
2013-12-23
695 reads
Being a Better IT Pro – Grammar
In my IT career, one of the things I have found that sets me apart is my ability to write....
2013-12-23
394 reads
SQL Server Pro Community Choice Awards
I’m a bit late posting this, but it’s worth a couple minutes to check out the Community Choice awards, might...
2013-12-23
920 reads
Master Data Services 2014: Creating nightly load processes
Introduction
A few days ago, I ran into an interesting issue when creating a stored procedure to load new data into...
2014-01-02 (first published: 2013-12-23)
3,507 reads
The Night Before Upgrade
I originally wrote this in December 2011. It’s been one of my most popular posts, so reposting it has become...
2013-12-23
456 reads
SSIS For Loop Skip Files
When running a For Each Loop through a set of files, sometimes you will have specific files that you do...
2013-12-30 (first published: 2013-12-23)
2,689 reads
SQL Server – Calculating elapsed time from DATETIME
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-23
101 reads
SQL Server – Calculating elapsed time from DATETIME
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-23
258 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