PowerShell – CHECK, START and STOP SQL Services of a remote servers
Replace a valid server name in the following examples. Try to do a testing on your local machine and understand...
2013-04-11
3,369 reads
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
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