Parameterizing SSRS Reports - SQL School Video
MVP Brian Knight continues with Reporting Services in this SQL School video that shows you how you can add parameters to your Reporting Services report to customize them.
2008-10-07
5,206 reads
Video
Creating a Database Diagram in SSMS - SQL School Video
In this SQL School video, Brian Knight shows you how to create and use database diagrams in Management Studio.
2008-10-02
5,305 reads
Modifying Data - SQL School Video
MVP Kathi Kellenberger covers the basics of using T-SQL to modify data in your databases.
2008-09-30
3,711 reads
Making SSIS Connections Dynamic - SQL School Video
Integration Services is an ETL programming environment that gives you a tremendous number of options. In this video, MVP Brian Knight shows how you can change your connections dynamically.
2008-09-25
6,026 reads
Execute an SSIS Package in SSMS - SQL School Video
This video shows how you can use Management Studio to execute your Integration Services packages.
2008-09-23
5,414 reads
Creating a Full Backup in SSMS - SQL School Video
This video shows you how to perform one of the core functions of a DBA: performing a full backup. The use of Management Studio is shown in this video.
2008-09-18
3,278 reads
Adding a timestamp to files in SSIS - SQL School Video
Integration Services is the ETL platform for SQL Server. In this installment of SQL School, Brian Knight shows how to add a timestamp (current date) to the name of a file.
2008-09-16
4,540 reads
Creating a Tabular Report - SQL School Video
SQL School continues with our series on Reporting services, this time examining how tabular reports can be easily built.
2008-09-11
4,891 reads
Creating a Matrix Report - SQL School Video
In this video, you will learn how to use Reporting Services to build a report that contains a matrix of data.
2008-09-09
5,141 reads
Creating a Data Mining Reporting Services Report - SQL School Video
In this new SQL School video, MVP Brian Knight shows us how to get started with data mining and Reporting Services retrieving data from an Analysis Services cube.
2008-09-04
6,985 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers