Trouble Shooting Little Jewel
I didn’t know about this little gem, so I shared it with my team and they didn’t know about it...
2017-03-29
709 reads
Watch Your DataTypes in Aggregates–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-29
1,003 reads
A First Look At Normalization
Phew! There’s a lot to take in with data types, collation, precision, scale, length, and Unicode, and we’re just getting...
2017-03-29
320 reads
Microsoft database migration tools
There are various Microsoft tools that you can use to help you migrate your database (updated 8/9/17):
Data Migration Assistant (DMA)...
2017-03-29
1,125 reads
Random Blogging Challenge Results
The winner is: Everyone.
Hey, the challenge was random. I didn’t promise a prize or a winner. Instead, I suggested everyone...
2017-03-29
649 reads
Increasing and decreasing the performance level of your Azure SQL Database
One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability...
2017-03-29
730 reads
What Is A Day?
When designing a data warehouse or reporting architecture, the smallest questions can pose some of the biggest challenges. Identifying what...
2017-03-29
613 reads
SSMS – Not a Valid Value for Property Width
I’ve had this happen a couple of times with a recent build of SSMS. Something went wrong – resolution change maybe...
2017-03-29
1,255 reads
Getting SQL Server File Sizes and Space Used with dbatools
I read a great blog post about answering the question how big is the database using T-SQL on SQL Buffet...
2017-03-29
986 reads
Using SQL Client Aliases
SQLServerCentral.com recently published my case study on how my company implemented Windows Containers running SQL Server to streamline our QA...
2017-03-29
177 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