(Chris Bell) I had a project once that was using change data capture (CDC) so we could minimize the data being sent to our data warehouse that was under development.
Tag: sql server
Microsoft Azure Stream Analytics
(Robert Sheldon) Azure Stream Analytics aims to extract knowledge structures from continuous ordered streams of data by real-time analysis. These streams might include computer network traffic, social network data, phone conversations, sensor readings, ATM transactions or web searches.
Automating SQL Server fragmentation management
(Greg Robidoux) SQL Server is a great data repository, but the real advantage of using SQL Server is the ability to query mass amounts of data to quickly find a particular set of data.
Store Optional Connection Parameters in SQL Server Management Studio
(Derik Hammer) About six months ago I wrote about the challenges of using the Always-On Availability Group Listeners with SSMS. At the time, I had presented three problems and only solutions for two of them.
Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches
(Paul Turley) This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty of SSAS Tabular projects over the past few years – usually starting with a Visual Studio project rather than Power Pivot.
Microsoft Azure SQL Database – Dashboard
(David Postlethwaite) Once you have created your database you can now start to manage and configure it.
SQL Server – Knowing Deprecated or Discontinued Features Using Extended Events
(Pinal Dave) This blog is in continuation to what I wrote couple of weeks back – SQL Server – Knowing the Use of Deprecated or Discontinued Features. The concept of using a deprecated feature is not by intensions by developers but is an accident for many.
Default database
(Kenneth Fisher) The default database is one of the options when creating a login in SQL Server. This is the initial database that the login will connect to when logging in.
Using R to Explore Data by Analysis – for SQL Professionals
(Feodor Georgiev) What’s the best way for a SQL programmer to learn about R? It’s probably by trying out various experiments with an interesting set of data, and some helpful suggestions that point out the parallels with SQL.
Monitor Storage Constraints for SQL Server Data Files
(Mike Eastland) In a previous tip, we covered one way to monitor free disk space on SQL Server. However, this is not the only storage constraint for SQL Server Database Administrators. Each file within a database can have limits imposed by its respective growth and max size parameters.
