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
141 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
162 reads
Blogs
FDD 2023 – Session Materials
You can find the slides for my session at Future Data Driven summit at...
Quick Filtering in SSMS–#SQLNewBlogger
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Penetration Testing your SQL Server, Part 1 – The Recon Mission
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
Forums
Write https request to azure blobstorage
Hi All, I have been trying to download a csv file which is produced...
High tempdb usage alternatives
Hi We have an stored procedure which runs frequently and it contain logic in...
high latency in sql server transactional replication
Hi I am new to replication and we have database of size around 2TB...
Ask SSC