Challenge 19 – An Explanation of a Query
I have received a number of requests for an explanation of my winning query of TSQL Challenge 19. This involved...
2010-05-27
1,714 reads
Blog Posts
Follow Up On My Keynote Survey
Here are the results of the survey, 75% in favor of a non-technical keynote, with a less than stellar sampling...
2010-05-27
623 reads
IndyTechFest 2010 a Big Hit
Jesse Liberty,a Developer Community Program Manager for Microsoft, starts off IndyTechFest 2010 with the keynote presentation.
On Saturday, May 22, 2010,...
2010-05-27
474 reads
North Texas SQL Server User Group Offers Innovative Educational Series
On Thursday, May 20, 2010, I had the opportunity to speak at the North Texas SQL Server Users Group, which...
2010-05-27
484 reads
SQLSaturday #49 Planning Update
Planning for SQLSaturday #49 – Orlando is on-going and going well especially since we have a good head start. We have...
2010-05-27
481 reads
The SSIS Data Flow is Like... an Automotive Assembly Line
When I describe (or rather, attempt to describe) technical subjects to people that aren't familiar with them, I tend to...
2010-05-27
471 reads
When did SQL Server start and how long is the downtime window?
This is an old topic, and there have been quite a few blogs (and following comments) that illustrate how to...
2010-05-27
3,743 reads
Connecting to DB2 using SSIS
To start, first download and install the Microsoft OLE DB Provider for DB2. Click here to download. After it is...
2010-05-26
21,877 reads
Kalen Delaney Speaking In Denver on June 9, 2010
Well-known SQL Server MVP and author Kalen Delaney (blog) will be speaking about SQL Server Plan Cache and Recompilation on...
2010-05-26
948 reads
Reporting Services – Building the first report
One of my goals this year was to spend some time learning Reporting Services. Not necessarily do the 10,000 hours...
2010-05-26
2,123 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