PASS Summit 2017
Hello all!
This past week was PASS Summit 2017, a super crazy/awesome week! So many great things happened this week and...
2017-11-07
99 reads
ROLLing UP Totals–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-11-06
1,753 reads
AWS – Move Data from HDFS to S3
In the big-data ecosystem, it is often necessary to move the data from Hadoop file system to external storage containers...
2017-11-06
356 reads
SQLSat Organizers and UG Leaders Meetings at PASS Summit - Tips and Tricks notes
At the SQLSat Organizers and UG Leaders Meetings at PASS Summit meetings last week, we were given an opportunity to share...
2017-11-06
330 reads
SSIS Basics: Integration Services Catalogs
In the new Project deployment model for SQL Server Integration Services, a new SQL Server database is used to provide...
2017-11-06
259 reads
Learning to Give Presentations Well (Part 1)
I’ve given technical presentations for years. I’ve also taught in churches and youth groups years before that. For me, speaking...
2017-11-17 (first published: 2017-11-06)
1,524 reads
DBA Definitions: FILLFACTOR
It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing...
2017-11-06
567 reads
Azure SQL Database Compatibility Levels
Let’s start off with a quick overview of SQL Server versions and compatibility levels.
100 = SQL Server 2008 and Azure SQL...
2017-11-06
525 reads
Getting Query Execution Statistics
If you hate things that are slow, I bet you certainly want to know the reason for the slowness. So,...
2017-11-17 (first published: 2017-11-06)
6,182 reads
SSDT How To Fix Error SQL17502
TLDR:
If you build an SSDT project you can get an error which says:
"SQL71502: Function: [XXX].[XXX] has an unresolved reference to...
2017-11-06
1,095 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers