Cache SQL Server Data in a .NET Web Application
One of the slowest parts of any application is data retrieval and in this article, we look at how to cache SQL Server data for a web application.
2023-05-22
Database Development
Self-Service Databases
When I first started work as a software developer, I knew that getting an environment set up where I could compile a project might take a few hours or a few days. The complexities of how people built software projects, the dependencies, and more were handled in a very immature manner. These days I can […]
2022-11-16
171 reads
Choosing State Over Migrations
Steve notes that there are differences between state based development and migration based development, but neither is necessarily better.
2021-10-06
238 reads
2020-11-13
111 reads
The Challenges of Resetting Databases
The challenges of state in databases can impact our development efforts.
2020-08-31
74 reads
Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines
In the second article of this series, Edward Pollack demonstrates some ways to design and populate a columnstore index to get even better performance.
2020-07-17
Understanding Auctions
We participate in auctions all the time even when we don’t realize it. In this article, Joe Celko discusses the many different types of auctions and how they work.
2019-11-25
SQL and Scope
Understanding scoping rules is a basic skill for developers. In this article, Joe Celko gives a bit of the history of scoping in early programming languages and shows how scoping applies to SQL queries as well.
2019-10-24
3 ways Managed Services Providers can offer more value
Redgate's Will Sharman explores ways that database MSPs can save time, minimize effort and work more efficiently, while at the same time providing more value to their customers.
2019-08-01
A MongoDB to SQL Server Migration: Data Typing and Un-nesting
Importing data from one system to another is a common task for database professionals. It’s possible to spend a lot of time figuring out what the schema should be for the target table. In this article, Rodney Landrum demonstrates an interesting solution to automatically figure out the data types and un-nest delimited data.
2019-07-08
Blogs
Power BI – Empowering Users to Disable Tooltips
By DataOnWheels
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...
Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS
One of the nice things about the Microsoft Connector for Oracle is that it...
ChatGpt Experiments–Getting Documentation
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
Forums
Changing a datasource using T-SQL Script
I've been looking for a way to change multiple data sources for reports to...
Azure SQL Revealed: A Guide to the Cloud for SQL Server
Comments posted to this topic are about the item Azure SQL Revealed: A Guide...
Refresh Limits
Comments posted to this topic are about the item Refresh Limits
Ask SSC