Understanding How to Use the UPDATE Statement to Change Your Data
Greg Larsen shows you a number of different ways to use the UPDATE statement to modify the data in your SQL Server tables.
2014-10-13
10,280 reads
Articles
Using the Konesans File Watcher Task in SSIS to Process Data Files
With the Konesans File Watcher Task for SSIS we can import files as soon as they arrive.
2014-10-10 (first published: 2012-08-13)
19,077 reads
Compare SQL Server Performance of In-Memory vs Disk Tables
With the release of SQL Server 2014 there came a lot of new features, including “In-Memory OLTP”. One would assume that storing a table in memory would most definitely be faster than using the conventional disk-based table storage engine. But just how much faster is it?
2014-10-10
8,756 reads
2014-10-09
30,278 reads
Deleting Files in the Cloud
The public perception is that, when something is deleted, it no longer exists. Often that's not really the case; the data you serve up to the cloud can be stored out there indefinitely, no matter how hard to try to delete it. Rob Sheldon investigates, and finds the cloud a worryingly public place.
2014-10-09
8,992 reads
SQL Saturday #337 - Portland, OR
SQL Saturday is coming to Portland on November 1! Join us for a free day of SQL Server training and networking. Speakers at this event include Red Gate's Grant Fritchey, Kathi Kellenberger, Benjamin Nevarez, and more. There are also 3 paid-for pre-con sessions for this event. Register while space is available.
2014-10-09
7,670 reads
2014-10-08
613 reads
Backup and Restore Strategies in SQL Server – Part 1
You need to set up backup and restore strategies to recover data or minimize the risk of data loss in case a failure happens. In this article series, Arshad Ali discusses backup and restore strategies in SQL Server.
2014-10-08
10,150 reads
Solving Kerberos Issues in SSRS When Running Beside IIS
When SSRS is running on a server with IIS, pass through Windows Authentication can be difficult to set up.
2014-10-07
9,265 reads
Improving the Quality of SQL Server Database Connections in the Cloud
To access SQL Server from the client, you use TDS protocol over TCP. This is fine over reliable LANs but over the internet these connections are relatively slow and fragile. TDS is still used to connect to databases in the cloud, but you need to use a combination of the new features such as connection pools and idle connection resiliency to make applications faster and more reliable. Edward Elliott shows you how.
2014-10-07
8,227 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
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...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers