MAC number from Query Analyzer
This procedure shows you the MAC number of your Enthernet card in a format exactly the same as when running: ipconfig /all from command shell. Updated thx to Larry A.
2003-05-31
137 reads
Returning data with col number
This script enables you to return data from SQL Server's table without specyfing the name of the column .All you only need to supply is the column number, that you want the data from. In the example we want to chose all rows from the second column (categories table - northwind) Column number is based […]
2003-05-07
156 reads
Blogs
DBA Myths: The system sessions are the ones with a session_id 50 or less
Anecdotally any session_id that’s 50 or less is going to be a system session...
SQL Undercover TV – Encrypting SQL Backups
In this episode, David looks at how we can encrypt our SQL Server backup...
Using volumes in SQL Server 2019 non-root containers
I’ve seen a few people online asking how to use docker named volumes with...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Issue with processing dimensions
Hi all I've got a weird one here. We have a multi-dimensional cube...
Maintenance Window for SQL Server Critical Alerts
Hello, We had some sql server have issues on some production servers. We actually...
Ask SSC