In this SQL School video, MVP Brian Knight dives into the Execute SQL task in Integration Services. You will learn how to add parameters to this task to customize its behavior.
2008-10-23
3,932 reads
Diving deeper into Reporting Services with this SQL School video, MVP Brian Knight shows how to create a report with a multi-select parameter, allowing the user to select multiple items for inclusion in the report.
2008-10-21
5,948 reads
Integration Services contains a tremendous number of ways to transform and work with data. MVP Brian Knight dives into the Row Count transform in this edition of SQL School. This shows how you can monitor the number of rows in a transform.
2008-10-16
3,471 reads
Reporting Services makes it easy to get data from a variety of sources, including Analysis Services cubes. In this SQL School video, Brian Knight shows how to use an SSAS cube as the dataa source for your reporting needs.
2008-10-14
5,390 reads
In this new SQL School video, MVP Brian Knight shows how you can schedule your SSIS packages to execute at a specific time or on a recurring schedule.
2008-10-09
5,518 reads
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,210 reads
In this SQL School video, Brian Knight shows you how to create and use database diagrams in Management Studio.
2008-10-02
5,311 reads
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,032 reads
This video shows how you can use Management Studio to execute your Integration Services packages.
2008-09-23
5,416 reads
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,288 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
WhatsApp: 0817839777, Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa Timur...
WhatsApp: 0817839777, Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
WhatsApp: 0817839777, Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers