Explicitly using tempdb with ##tables
I had someone ask me last night if this statement would create a permanent table in tempdb with a strange...
2016-04-25
1,702 reads
Monday Morning SQL Break – April 25, 2016
It’s Monday and if getting a start on the week is as exciting for you as it is for me, it’s...
2016-04-25
519 reads
Upcoming Florida IT Pro Camps
Two IT Pro Camps coming up, register soon!
IT Pro Camp – Jacksonville FL – June 11 at Keiser UniversityIT Pro Camp – Tampa...
2016-05-05 (first published: 2016-04-25)
1,034 reads
Get your SQL Server MCSA without taking the BI exam.
I’m a big fan of certifications as a training exercise. However not everyone has the same interests. With the new...
2016-04-25
1,838 reads
Partition to Filegroup Mapping in SQL Server
Suppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition...
2016-05-05 (first published: 2016-04-25)
2,839 reads
Speaking at SQLSaturday Pensacola
I’m proud to announce that I will be speaking at SQLSaturday Pensacola on June 4th 2016! This will be my second SQLSaturday event and I’m really excited that I get to...
2016-04-23
11 reads
Speaking at SQLSaturday Pensacola
I’m proud to announce that I will be speaking at SQLSaturday Pensacola on June 4th 2016! This will be my second SQLSaturday...
2016-04-23
404 reads
SQLSaturday Atlanta #521 May 19th & 20th 2016
SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more...
2016-04-23
638 reads
Colorblind Awareness and Power BI KPIs
Update: The ability to change the color of a KPI was delivered in August 2016!
Color blindness, or color vision deficiency (CVD)...
2016-04-23
600 reads
Upcoming Webinars
Next week I am participating in two exciting webinars that I want to share with you!
Improve App Uptime: Tips from MVP...
2016-04-22
531 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers