How to retrieve Linked Server CPU utilisation details?
If you are suffering from poorly performing linked server queries, you may wants to investigate the Linked Server CPU utilisation statistics. Following T-SQL script retrieves information such as SQL Process utilisation, System Idle time and Other Process utilization for a preconfigured MS SQL...
Read MoreScript to find failed SQL Server Agent Jobs
It’s handy to have a script to find failed SQL Server Agent Jobs. Most of the organizations execute resource intensive SQL process such as backup, heavy ETL process at night and it is essential to validate those import process daily...
Read MoreScript to retrieve latest database backup details from preconfigured Linked Server
Below script can be used to retrieve latest backup file datetime and physical location for all the Databases in preconfigured Linked...
Read MoreHow to retrieve Linked Server configuration details?
Sometimes you may wants to retrieve a linked server configuration details. Following T-SQL statement retrieves information such as Hostname, SQL Instance name, Server Edition (32 bit or 64 bit), IP address, Port , ServicePack and cluster configuration for a preconfigured...
Read MoreBeginning SSRS – Part 3 Datasources and Datasets
The third part of our Beginning SSRS series. An important lesson covering the embedded and shared datasources and datasets, as these are the bedrock for all...
Read MoreBeginning SSRS – Part 2 Basic expressions / Conditional Formatting
This is the second video in our Beginning SSRS Series. In this video we show you how to carry out basic expressions to change font colours, font weights, alternating row...
Read MoreT-SQL Exam questions and answers – Part 10
Questions
Q1. Which of the following function would you consider using to get the day (day of the month) of the specified date?A. DAY()
B. DATE()
C. YEAR()
D. GETDATE()
Q2. Which of the following function would... Read MoreT-SQL Exam questions and answers – Part 9
Questions
What will be the correct output of following T-SQL statements? Q1. [crayon-5f00bfdc04a1a144852052/]A. 199.0099
B. 199
C. 199.01
D. 199.0009
Q2. [crayon-5f00bfdc04a22243841489/]A. 10
B. 20
C. 40
D. 8
Q3. [crayon-5f00bfdc04a26703722277/]A. 0
B. -1
Beginning SSRS PT 1 – Our first report
This is the first video in a series entitled "Beginning SSRS" - we are going to show you how to start with the basics of SSRS and work our way through to more advanced SSRS topics. If you want to...
Read More