My TechEd Presentation: Indexing Fundamentals for Microsoft SQL Server
This past Monday, I presented at TechEd North America for the first time. The session presented was Indexing Fundamentals for...
2013-06-06
650 reads
Speaking in Denver and Boulder in June
I will be speaking at the Boulder SQL Server User’s Group on June 18, 2013 and at the Denver SQL...
2013-06-06
950 reads
IT recruiter’s response
I asked a recruiter to check out my blogs about consulting, and his response is below. He had some good...
2013-06-06
891 reads
Building a SharePoint 2013 BI Demo Environment Part 6 – Installing PowerPivot for SharePoint
Before we can configure SharePoint, we will have to install the Analysis Service instance that will host the PowerPivot workbooks...
2013-06-06
3,395 reads
Why Anti-Virus Offers Limited Protection
Sitting in the first Keynote for the 2013 Techno Security and Forensics Investigation Conference, I was not surprised to hear Kevin...
2013-06-06
1,497 reads
SSAS Cube Backup strategies and Step by Step approach to setup and configure backup
There are different ways to take Cube database backups.
SQL Agent JobXMLA script for backupROBOT jobASCMD commandSSIS PackageSSIS packageAMO (Analysis Management...
2013-06-11 (first published: 2013-06-05)
2,963 reads
How to Avoid a Database “Heart Attack”
For the past couple of months I have been working with Ben Weiss a Digital Marketing Strategist at Infusive Solutions (http://www.infusivesolutions.com/)....
2013-06-05
520 reads
SQL Query Result Order
Every time an SQL query is run without the ORDER BY clause, the sort order of the results returned is...
2013-06-05
649 reads
An interview with Alex Whittles Chairman of SQLRelay 2013
Some of you may recall in January I ran a series of interviews entitled “New Year Aspirations”. This interview was...
2013-06-05
869 reads
Easy way to generate a restore script.
Easy way to generate a restore script.
I was asked today if I had a canned restore script handy. I don’t....
2013-06-05
1,005 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...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
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...
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