Add a linear trendline to a graph in SQL Server Reporting Services
In this article, Koen Verbeeck illustrates how to add a linear trendline to a graph in SSRS, similar to the way it would appear if done Excel.
2015-01-06
7,705 reads
Articles
SQL Monitor Custom Metric: Identity Columns Near Limit
If your application relies on identity columns, this metric is a useful measure of the number of identity columns that are near to the limit per database. You can then avoid logical problems in your application and SQL Server errors.
2015-01-06
6,226 reads
Adding an Article Without a Full Snapshot
Have you got transactional replication in your SQL environment? Do you need to add a new table to your publication, but can't afford the time necessary to create a full new snapshot? Here is a step-by-step guide. Thankfully, adding a single table is easier than I thought.
2015-01-05
22,320 reads
Salesforce: A Very Straightforward Cloud Development Platform
Force.com is an enigma; a Platform-as-a-Service that is designed to appeal to a broad church of developers, to make it quick and easy to write simple cloud-based applications. Robert Sheldon explains, as simply as possible, why this unusual data-centric, and metadata-driven platform is attracting so much interest in the industry.
2015-01-05
7,123 reads
Creating a heat map in Reporting Services
Use custom assemblies to generate a heat map matrix in SQL Server Reporting Services
2015-01-02 (first published: 2012-08-30)
17,768 reads
Growing Your SQL Server Skills without Breaking the Bank
Learning more about SQL Server doesn't have to cost a small fortune. If you're willing to invest the time, you can learn.
2015-01-02 (first published: 2013-08-05)
14,531 reads
High Availability and Disaster Recovery for Small Businesses
Too often in the past, High Availability and Disaster Recovery have been marketed as expensive choices for businesses with deep pockets. The truth is that, with careful planning, there are sensible and economic solutions for small businesses that can maintain business continuity when disaster strikes.
2015-01-02
9,346 reads
A Beginners Look at Hadoop
Hadoop has been making a lot of noise in the Big Data world. Despite my lack of Linux experience I decided to take the plunge and this is what I found.
2015-01-01 (first published: 2013-06-05)
24,191 reads
Getting Started with HDInsight - Part 3 - Creating an HDInsight Cluster in Microsoft Azure Cloud
In this tip we will look at two different ways of creating an HDInsight Cluster: Creating an HDInsight Cluster through Azure Management Portal, and creating an HDInsight Cluster through Windows Azure PowerShell.
2015-01-01
6,840 reads
SQL Server Data Import System to Alert For Missed Imports
In this tip Tim Smith looks at how to set up a system that allows automatic notification if a process doesn't import new data into SQL Server.
2014-12-31
6,405 reads
Blogs
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers