Exploring Excel 2013 for BI Tip #6: GeoFlow–The Latest Excel Visualization
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-04-23 (first published: 2013-04-11)
3,337 reads
Find SQL Server Installation – Date and Time – 2005 Onwards
SELECT create_date as ‘SQL Server Install Date’ FROM sys.server_principals WHERE name=’NT AUTHORITY\SYSTEM’
2013-04-10
698 reads
PowerShell – Pattern Search – Local or Remote Folder
#Description : List all the files of a local or remote drive, run this PowerShell script using PowerShell-ISE.exe for better execution...
2013-04-10
735 reads
Set DAC port with a specific number
Usually named instance can uses dynamic port, if firewall setup on the server, you can use SQL Server Configuration Manager...
2013-04-18 (first published: 2013-04-10)
5,091 reads
SSRS Map Label Overlap Fixed
In Reporting Services 2008 r2 and above there is a great tool called the Map tool. It is great for...
2013-04-10
971 reads
Staggering SQLIO Sessions Across Multiple Volumes
In a previous post, I discussed running SQLIO against multiple files. The purpose in using multiple files is being able...
2013-04-22 (first published: 2013-04-10)
2,013 reads
SQL Server 2000 is unsupported
Microsoft no longer supports SQL Server 2000 in any capacity.
http://youtu.be/A5cneCgNA9U
2013-04-10
821 reads
Run DBCC CHECKDB on a regular basis
Problem One common task as DBA is to run DBCC CHECKDB on a regular basis to detect and correct potential corruption...
2013-04-18 (first published: 2013-04-10)
11,890 reads
DMV-6 : How well my store procedure doing ?……..sys.dm_exec_procedure_stats
sys.dm_exec_procedure_stats DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/cc280701.aspx
Returns aggregate performance statistics for cached stored procedures. The view...
2013-04-10
1,908 reads
Las Vegas April 2013 UG Meeting
AlwaysOn – Finally, A usable ‘mirror’! In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not...
2013-04-10
6 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