You Can Still Vote for PASS
If you couldn't vote last week or didn't get a ballot, you still can. Please go to www.sqlpass.org and learn more.
2014-10-03 (first published: 2014-09-29)
493 reads
Articles
Ninja Immutable Databases
'Immutable' databases operate under the principle that data or objects should not be modified after they are created. Once again they hold the promise of providing strong consistency combined with horizontal read scalability, and built-in caching. Are Immutable databases a new idea? Are they different in any way from the mainstream RDBMSs?
2014-10-03
9,305 reads
Data Compression and Snapshot Isolation
Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit
2014-10-02
3,727 reads
Protect Confidential SQL Server Data Q and A
Following on from a webcast, Tim Smith answers some questions on SQL Server security like: Is It Better To Mask At the Application Level Or The SQL Server Database Level? Are there any options to find SSNs in SQL Server besides RegEx? And, why would anyone store sensitive data un-encrypted in SQL Server?
2014-10-02
8,457 reads
Filling In Missing Values Using the T-SQL Window Frame
Since SQL Server delivered the entire range of window functions, there has been far less justification for using the non-standard ex-Sybase 'Quirky Update' tricks to perform the many permutations of running totals in SQL Server. One of these related problems is the 'Data Smear'. Do window functions make this easier, and what is performance like? Dwain Camps investigates.
2014-10-01
11,294 reads
2014-09-30 (first published: 2010-05-25)
66,273 reads
Synchronize Salesforce with SQL Server using SSIS
Easily synchronize live Salesforce data with SQL Server using the Salesforce SSIS DataFlow Tasks.
2014-09-30
7,297 reads
Change All Computed Columns to Persisted in SQL Server
Aaron Bertrand recently answered a question from a user who wanted to convert all of their SQL Server computed columns to be persisted. This allows you to shift the SQL Server cost of performing the computation from query time to the time of the insert/update, at the cost of storage. In this tip, Aaron shows you how.
2014-09-30
8,294 reads
Webinar: 7 Steps to Build a Database Deployment Pipeline
Join Red Gate’s Alex Yates and TeamCity for a free webinar this Thursday, October 2nd. In this practical demo, Alex will show you how to set up continuous delivery for your SQL databases using TeamCity, Red Gate’s SQL Automation Pack, and Octopus Deploy. Places are limited – register now.
2014-09-30
8,081 reads
Removing SQL Server Management Data Warehouse (Data Collector)
Learn how to remove the MDW from your SQL Server environment with the 2008, 2008 R2 and 2012 versions.
2014-09-29
5,192 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers