Date Range
Date Range
Date Range
SQL Server management and database administration. Database development and continuous integration. ApexSQL Source Control 2018 R3 Product update alert. ApexSQL Source Control 2018 R3. ApexSQL BI Monitor 2018 R2 Product update alert. ApexSQL BI Monitor 2018 R2. ApexSQL Refactor 2018 Screen shot tour. ApexSQL VM Monitor 2018 R2 Product update alert.
The Art of Aggregating Data in SQL from Simple to Sliding Aggregations. Let us start our SQL journey to understand aggregating data in SQL and types of aggregations including simple and sliding aggregations. Before we jump to the aggregations, it is worth considering interesting facts often missed by some developers when it comes to SQL in general and the aggregation in particular.
I did promise to announce the winners of the SQL Test competition. I ran recently on this blog. Improve Your Database Unit Testing Skills and Win Free Stuff.
This site is a collection of my thoughts, mostly on data architecture and the cloud. The links above will take you to my blog, my open source projects, presentations I have delivered that may interest you, and services and products that I offer. I use this site to showcase my work and help me organize my thoughts and learn. I can help you make the most of it. I am a data and cloud architect and currently the Chief Technology Officer for Capax Global.
Test driven database development links. A couple of interesting articles about test driven database development and the database testing framework tsqlt. 8211; worth taking a look at. Test-driven Database Development Why Bother? Test-driven Database Development Why tSQLt? Posted by Michael Baylon. Unit testing update sprocs where more that one table is updated. This blog will look at a slightly more complex scenario to testing an update that affects 2 base tables.
Domain Privacy Service FBO Registrant
1958 South 950 East
Provo, Utah, 84606
US
News and Updates for T-SQL Tidy. An On-line Transact-SQL parser and formatter. Tuesday, 4 November 2014. New Podcast on Technology and SQL Server - Sounds of SQL. There are some really goods ones on tech I listen to like; . The interviews will be going up on Sounds of SQL.
Tables, Columns, Rows. What is an index? This site will primarily focus on T-SQL used with Microsoft SQL Server. Most examples are for Microsoft SQL Server 2005, but most will work for earlier and later editions. The site will be updated as new editions of SQL Server are released.