Exploring Excel 2013 for BI Tip #7: Retaining Pivot Table Size After Data Refreshes
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-05-23
730 reads
Business Objects on Linux and SQL Server
This is just a quick post to share a lesson learned while I was on an engagement where the client’s...
2013-05-23
978 reads
Dedicated Administrator Connection (DAC)
We all dread the scenario whereby SQL Server is under so much load and has a complete lack of resources...
2013-05-29 (first published: 2013-05-23)
4,366 reads
Starting with Azure
I’ve been meaning to do this, and I finally had the chance recently to start working with Azure. Red Gate...
2013-05-27 (first published: 2013-05-23)
2,606 reads
SQL Server – Get the Default Data File and Log File Location using T-SQL Query
In SQL Serve 2012, we can get the default data file and log file locations using a simple T-SQL query...
2013-05-23
665 reads
DR planning article up at MSSQLTips!
My latest article is up at MSSQLTips.com:
Disaster Recovery Planning for Microsoft SQL Server - Getting Backups and Restores Right
For more of...
2013-05-23
847 reads
Giving an SSIS security webinar with Andy Leonard
Andy Leonard (blog | twitter) and I are teaming up to do a security presentation on SSIS. It's scheduled for Wednesday, May...
2013-05-23
1,046 reads
Ad-hoc Reporting with SharePoint Recording and Q&A
I hope you were able to attend my free webinar on Ad-hoc Reporting with SharePoint on May 21, 2013. If...
2013-05-23
1,246 reads
Speaking at SQL PASS Summit 2013
WOW! I was selected to present at the SQL PASS Summit 2013 in Charlotte, NC. in October! All I can...
2013-05-23
567 reads
The Bicentennial SQLSaturday–#200 Philadelphia
When Andy Warren (b | t | Li)started SQL Saturday with #1 in Orlando, we weren’t sure it would succeed. After a...
2013-05-22
907 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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