24 Hours of PASS: Business Analytics Edition videos online
On January 30, BA and BI experts took to the virtual stage for the 24 Hours of PASS: Business Analytics Edition to...
2013-02-07
775 reads
A Month of PowerShell – Day 7 (Script Input/Output)
Welcome to Day 7 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-07
1,881 reads
SSRS Date Parameters for Cube Based Datasets
To have a ‘date picker’ report parameter on your SSRS reports the process works the same on all versions of...
2013-02-07
3,704 reads
Announcing SQL Saturday 197 Omaha Pre-Cons!
Here is a flyer produced by someone on the team - he says it all very well:
--
Friday, April 5, 2013
Get Warmed...
2013-02-07
812 reads
Move or Relocate the files of Resoruce Database in SQL Server 2005
The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL...
2013-02-07
720 reads
Avoid This Time Scheduling Mistake
I was recently asked by a project manager to lay out when DBAs would accomplish certain tasks for a particular...
2013-02-07
1,415 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 6: Association Rules
by Steve Bolton
In last week’s installment of this series of self-tutorials on SQL Server Data Mining (SSDM), we covered...
2013-02-07
2,562 reads
One Slick Solution and Unexpected Consequences
Quite a few years ago my first job in the military was driving a tracked vehicle, a variant of the...
2013-02-07
764 reads
EXECUTE, not required, but advisable.
The other day one of the developers I work with gave me a script similar to this:
BEGIN TRAN
sp_rename 'tablename.columnname', 'newcolumnname'
COMMITHe...
2013-02-06
781 reads
Quick alert on servers which are not compliant for policies set using PBM
Last month I wrote about leveraging policy based management for regular DBA compliance checks. You can read that post here.
Policy based management(PBM) is indeed...
2013-02-06
813 reads
Blogs
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...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers