SQL Saturday is a full-day technical conference and training event with international speakers. With over 20 sessions on SQL Server and a separate pre-con, the event is aimed at all those interested in SQL Server - from pros to beginners. This event will be on February 28, 2015, so register while space is available.
2015-02-06
6,987 reads
After discussion the main concepts and basic API calls for Azure Storage Queues in parts 1 and 2 of this series, Roman Schacherl turns his focus to two topics that no one likes to implement but everybody needs: security and performance.
2015-02-05
7,183 reads
SQL Server Data Collector, together with Management Data Warehouse, is a fine and useful component for gathering information centrally about how SQL Server instances are being used, and thereby keeping an eye out for problems. It comes into its own when you have figured out how to configure it to run on maybe hundreds of instances using Central Management Server. Dennes describes how to tame the system so that it scales.
2015-02-04
8,923 reads
Big data is everywhere, and most large IT enterprises have installed one or more big data applications. These applications provide fast access to large stores of data, usually customer or sales data. Your technical staff that supports these applications and the systems that analyze and consume the data didn't exist ten years ago. Who are these new IT professionals, and how should you manage them?
2015-02-03
8,327 reads
SQL-based distributed Cloud Relational databases aren't new, but Amazon's Aurora offers an alternative to SQL Azure, and, being MySQL-compatible, provides the obvious route to the cloud for hosted LAMP web applications.
2015-02-02
8,160 reads
ETL ( Extract, transform, load) doesn't have to be like a spell on hell. To make a success of ETL systems, you need the freedom and ability to make graceful U-turns when you detect a mistake in architecture or configuration: to fix the root problem rather than to merely tackle the symptoms. Feodor lists the eight most common root causes of failure in ETL systems, and how to fix them.
2015-01-30
13,243 reads
In data mining, we sometimes need to perform techniques such as Z-score normalization on numeric data type columns to prevent one column from skewing or dominating the models produced by the machine learning algorithms. Dallas Snider explains how to perform this in SQL Server with T-SQL code.
2015-01-29
9,049 reads
If you can examine and understand execution plans, you can achieve better understanding of the database system and you will write better database code. Grant Fritchey shows you how.
2015-01-28
9,282 reads
The easiest way to determine if there is encrypted data in a database is to get that information from whoever wrote the application. Aside from that, there are a few things you can look for which would suggest that you have encrypted data in a given database.
2015-01-27
7,810 reads
Not all data is discrete; some data types represent a continuum. In SQL, we have to approximate them and live with the special problems of handling continuous data. We need to understand the problems associated with continuous data types, when these will happen, and how it affects constraints and the results of queries. Joe Celko explains.
2015-01-26
8,731 reads
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Comments posted to this topic are about the item How Can SQL Server Detect...
Comments posted to this topic are about the item Getting Database MaiL Profiles
Comments posted to this topic are about the item Preserving Data
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers