Exporting data with header using Powershell
Extracting data with header information using PowerShell
2014-04-28 (first published: 2014-04-07)
1,506 reads
Scripts
2014-04-24 (first published: 2014-04-05)
2,013 reads
Restore script genrator for moving dbs
usefull script for moving databases from one server to another
2014-04-23 (first published: 2014-03-29)
955 reads
2014-04-22 (first published: 2014-02-20)
2,203 reads
backup, differental and transactions
Backup all databases for an instance (complete, Differential or log of transactions)
2014-04-21 (first published: 2014-04-05)
1,092 reads
Get the defination of all table type in database
THis script will generate the Drop and create script for all user define table type
2014-04-18 (first published: 2014-03-25)
1,216 reads
2014-04-17 (first published: 2014-03-25)
1,330 reads
2014-04-14 (first published: 2014-03-18)
7,024 reads
Get the Column level difference for 2 database
The query will help to get the column level difference for 2 database(Like Prod and Dev database). This help us to verify what are the column changes has been done in dev environment after Prod deployment.
2014-04-10 (first published: 2014-03-11)
1,069 reads
Find dependencies between field and sp/function
This script shows the stored procedures and functions affected by field name change in a table.
2014-04-09 (first published: 2014-03-18)
1,082 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers