SQLServerDBA News - 2011 Review for SQLServerDBA
2011 was a great year on a personal and professional level
1) Completed the Brighton Marathon in 4hrs 36 secs
2) Blogged...
2011-12-31
1,561 reads
- Interests: Performance Tuning Database Servers, Running and Coffee
Top 10 SQL Server Posts for 2011
2011 is nearly over. It’s time to list the Top 10 viewed SQLServer-DBA.com posts for the year , based on Views.
System...
2011-12-24
821 reads
Routing OSPF and Network Team
After a server move to the failover Data Centre – a file copy between the two sites slowed down by 6x. ...
2011-12-21
655 reads
Nic Teaming
Network card teaming or NIC teaming are networking terms describing methods of combining multiple parallel network connections . The main purposes...
2011-12-14
1,745 reads
CPU Count
I document the CPU Count for SQL Server inventory management.
Using a powershell script , iterate through all the SQL Servers and...
2011-12-13
964 reads
SQL Traces and c2 auditing are different
Sometimes end users interchange the terms : C2 auditing and Traces.
They server different purposes.
c2 auditing records all attempts (successfull and...
2011-12-12
827 reads
SQL Database Status with sys.databases
I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column...
2011-12-09
845 reads
SQL Server Latency
Latency is the time delay measure in the system. SQL Server can only be as fast as the slowest component...
2011-12-07
1,819 reads
DATEADD and variables in SQL
To make the T-SQL function DATEADD more dynamic use variables. The example below , accepts an input parameter , in this case...
2011-12-06
2,313 reads
Enable XA transactions for SQL Server
An XA transaction is a global transaction usually covering multiple resources.
Use the Microsoft SQL Server JDBC Driver to support the ...
2011-12-05
209,164 reads
Blogs
Using SQLFluff
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Marketing Analyst: The Data-Driven Superhero Your Company Needs
Want to blend your love of marketing with the power of data? Becoming a...
Can You See Table Valued Parameters in Extended Events?
I live for questions and this was an interesting one. Can you see Table...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Azure SQL database import permissions
What the required permissions are for "Database import" on an Azure SQL database ...
Migrating MDS model individually using MDS UI
Hi All, Is there a way i can create package for an individual...
Question of the Day
Column Adds and Drops
I run this batch on SQL Server 2022. What happens?
ALTER TABLE dbo.Accounts ADD AccountAccessType INT GO ALTER TABLE dbo.Accounts DROP AccountAccessType GOSee possible answers