It's not recommended, but sometimes writing scripts against the system tables and getting information is a great way to work with SQL Server. Alex Grinberg brings us a look at some of the things you can get from system tables along with some sample scripts.
A question came up on an internal alias about how can one download a file over HTTP. Here's a script that does that, should be trivial to wrap it inside a task if you forsee doing this over and over again.
This shows you how to use the Script Transform to make intelligent decisions about your data and clean it appropriately.
In this review, Brian reviews one of his favorite tools in his DBA toolkit. He shows you some of the new features in this event management system and how it can shave hours off your day each day.
Continuing the coverage of debugging features in SQL Server 2005 Integration Services Data Flow, which we started in the previous installment of this series, we will now focus on the Script Component.
SQL Server 2005 has deprecated osql and isql as command line tools and replaced them with SQLCMD. Haidong Ji brings us an introduction to this new tool and a few tricks to make you more productive when using it.
sqlSentry, a leading developer of management solutions for Microsoft SQL Server, today announced that it has released the 64-bit version of its industry-leading scheduling and notification management system for SQL Server 2005, supporting both x64 and Itanium-based systems.
One would think that when you have to work with Unix text files, they would be the same as Windows text files. That is not quite the case and Peter Ward brings us a look at how this caused a problem in DTS and a way you can fix it.
The alternative to surrogate keys is natural data keys. In order to understand the many substantial benefits of surrogate keys it's necessary to discuss some background on the issues involved.
In this lesson, we revisit usage-based optimization, a subject that we undertook in my article MSAS Administration and Optimization: Simple Cube Usage Analysis, in September of 2003, and MSAS Administration and Optimization: Toward More Sophisticated Analysis in October of 2003. In the earlier articles, we discovered that, among several tools that Microsoft SQL Server 2000 Analysis Services offered us to assist in the maintenance and optimization of our cubes, two of these tools, the Usage Analysis Wizard and the Usage-Based Optimization Wizard, leveraged the usage-based optimization features of Analysis Services.
By Steve Jones
I needed to back up a PostgreSQL database as a part of the repro...
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
Hi all, First I want to ask just a generic question. Does RLS in...
Reading the Microsoft documentation it says SQL2019 STANDARD EDITION has a max memory of...
I have installed the SSIS extension for VS 2022 community. When I go into...
I have this data in a table?
CatIDCatName 3MonitorsWhat is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS cSee possible answers