How to Find the SQL Server Version
This article shows a number of ways in which you can find out the version of your instance.
2023-06-23
6,899 reads
Nisarg Upadhyay
T-SQL Scripts to generate the HTML-formatted database storage report
This article will show how to generate an HTML formatted report of your disk space.
2023-06-12
6,586 reads
How to Find the SQL Server Instance Startup Time
Learn a number of methods to view or programmatically get the SQL Server instance startup time.
2023-05-12
8,996 reads
How to Create a SQL Database on a New Drive in Ubuntu
This article explains different methods to move a SQL database into a new directory of Ubuntu Linux. This article covers the following topics. How to install SQL Server 2022 on Ubuntu Linux. How to add a new drive in Linux. Attach the StackOverflow database using the database. Install SQL Server 2022 on Ubuntu I have […]
2023-05-10
1,995 reads
Create an HTML Report on the Status of SQL Server Agent Jobs
SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set of tasks and commands at specified intervals, ensuring the database is up-to-date and performing optimally. As a database administrator, it is essential to regularly monitor the status of SQL Server jobs. One way to do this is […]
2023-05-03
8,357 reads
Create an Empty Database Using SQL Server Integration Services
Learn how to create a copy of an existing database without any data using Integration Services.
2023-04-17
3,615 reads
Find Invalid Objects in SQL Server
This article shows how you can find which objects in your database might not be valid after schema changes.
2023-03-13
22,057 reads
How to store Excel files In SQL Table
This article will show how to store images, document and all other files in SQL Table.
2017-12-07
20,216 reads
Change Integer to BigInt on a Very Large Table
This article will show how to change the data type of a column when the table contains more than 1 billion records.
2017-11-09
5,464 reads
Parameter Sniffing In Action
This article will demonstrate what is parameter sniffing and how can it can kill performance
2017-10-24
2,127 reads
Blogs
Chatting with Power BI: Who Benefits from This Conversation?
By Rayis Imayev
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Prepping for Certification, Part 2 of ?
By Brian Kelley
The advantage of understanding the make-up of the exam: I can tailor my efforts...
Forums
SQL Server 2025 Build List
Comments posted to this topic are about the item SQL Server 2025 Build List
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers