Using PowerShell to Manage Windows Azure SQL Databases
Marcin Policht provides a comprehensive overview of Windows PowerShell’s capabilities in regard to managing SQL Databases (or, in general, cloud-resident resources).
2014-07-18
3,207 reads
Articles
Developing a Custom SSIS Source Component
SSIS was designed to be extensible.Although you can create tasks that will take data from a wide variety of sources, transform the data is a number of ways and write the results a wide choice of destinations, using the components provided, there will always be occasions when you need to customise your own SSIS component.
2014-07-17
13,344 reads
Automate Registering and Maintaining Servers in SQL Server Management Studio (SSMS)
This tip looks at how to use a control file that lists the structure to use within SSMS and a PowerShell script that will automatically maintain the list of registered servers within SSMS.
2014-07-16
12,484 reads
SQL Saturday #302 - Albany
SQL Saturday is coming to Albany, NY on July 26, 2014. This is a free full day of training and networking for SQL Server professionals. This event also features a paid-for precon session with Grant Fritchey on query performance tuning. The event is soon so register while space is available.
2014-07-16
9,085 reads
Version Control as a Cloud Service
Robert Sheldon wonders if cloud-based version control still too risky for a service that must be secure, and risk-free?
2014-07-15
11,224 reads
2014-07-14
146 reads
SQL Monitor Metric: Memory used by ad hoc queries running once
This metric measures the amount of memory used by the total number of ad hoc queries in the plan cache that have only run one time. This value is only accurate for the instant the query is run, and the value can change radically from one capture time to the next.
2014-07-14
9,595 reads
SQL Server Analysis Server (SSAS) KeyColumn vs NameColumn vs ValueColumn
What is the difference between the KeyColumn, the NameColumn, and the ValueColumn for a dimension attribute in SQL Server Analysis Services? When should you use each one for a dimension attribute? Check out this tip to learn more.
2014-07-14
10,530 reads
Single Quotation Marks in SQL
One of the common problems is dealing with apostrophes in T-SQL. This article examines the challenges of single quotation marks and ends with a short quiz.
2014-07-11 (first published: 2013-01-03)
36,344 reads
Do You Really Need to Tune Big Data Applications?
Big data applications are here to stay. The promise of this technology is the ability to quickly and easily analyze large amounts of data and derive from that analysis changes to customer-facing systems, hopefully at a reasonable cost. So, do these applications really need tuning?
2014-07-11
4,426 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers