T-SQL Programming Darko Martinović in T-SQL Programming SQLCLR Email in SQL Server: Build a Custom sp_send_dbmail Alternative Build a SQLCLR stored procedure for sending email from SQL Server without sp_send_dbmail. Covers .NET SMTP integration, custom email profiles,... 17 July 2017 36 min read
BI Saurabh Desai in BI The Best of Both Worlds: Using Excel and Power BI Together Excel and Power BI work well together. This allows you to use the two tools together to provide for many... 17 July 2017 12 min read
Database Administration Laerte Junior in Database Administration SQL Server High CPU: Investigating the Causes Any DBA who is trying to find the cause of an intermittent problem such as SQL Server high CPU dreams... 17 July 2017 9 min read
BI Robert Sheldon in BI SQL Server R Services: Digging into the R Language It is not just the analytic power of R that you get from using SQL Server R Services, but also... 17 July 2017 16 min read
T-SQL Programming Joe Celko in T-SQL Programming SQL Data Aggregation Aggravation When we have to deal with and store a lot of data, it makes sense to aggregate it so that... 17 July 2017 10 min read
Other Dennes Torres in Other Using R to illustrate relationships from graph objects My new article about Graph Database Objects was just published, it’s really a very good new feature. Another new feature... 06 July 2017 3 min read
T-SQL Programming Dennes Torres in T-SQL Programming SQL Graph Objects in SQL Server 2017: Pros, Cons & Examples Evaluate SQL Server 2017 graph objects: node tables, edge tables, MATCH queries, with a relational vs graph model comparison. Covers... 05 July 2017 29 min read
Phil Factor Statistics in SQL: The Mann–Whitney U test Imagine you have some data. Maybe you’ve done a web redesign and you want to do some A/B testing to... 30 June 2017 6 min read
Other Dennes Torres in Other SQL Server 2017: New ‘Queries with high variation’ Graph A few weeks ago I published an interesting article about how to use query store to identify parameterization problems. At... 30 June 2017 3 min read
Other Dennes Torres in Other New T-SQL Functions in SQL Server 2017 SQL Server 2017 brings us some new T-SQL functions. They are very simple to use, and can also help us... 28 June 2017 5 min read
T-SQL Programming Robert Sheldon in T-SQL Programming The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to... 27 June 2017 17 min read
Database Administration Laerte Junior in Database Administration Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) for SQL Server is... 27 June 2017 8 min read
Other Phil Factor in Other SQL Server IsNumeric vs TRY_CAST and TRY_CONVERT: Why IsNumeric Gives Misleading Results Why IsNumeric() returns true for values that can't actually be cast to numeric types - currency symbols, commas, scientific notation,... 23 June 2017 17 min read
Database DevOps William Brewer in Database DevOps Database Code Analysis Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the... 20 June 2017 12 min read
Other Dennes Torres in Other SQL 2017 new DMF: Managing VLOGs in our databases SQL Server 2017 brings to us some new interesting DMV’s and DMF’s, one of them is sys.dm_db_log_info. This new DMF... 20 June 2017 4 min read
BI Robert Sheldon in BI SQL Server R Services: The Basics It is possible to do a great deal with R within SQL Server, but it is best to start by... 19 June 2017 18 min read
BI Amarendra Reddy Thummeti in BI Developing Metadata Design Patterns in BIML You may have already experienced ETL Hell, where you have a large number of similar of SSIS tasks, and a... 06 June 2017 22 min read
Database Administration Dennes Torres in Database Administration Parameter Sniffing: Fix It with Query Store Diagnose and fix SQL Server parameter sniffing problems using Query Store. Identify bad plan reuse, compare execution plans, and force... 06 June 2017 25 min read
T-SQL Programming Robert Sheldon in T-SQL Programming The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects Technical debt is a real problem in database development, where corners have been cut in the rush to keep to... 02 June 2017 22 min read
Other Dennes Torres in Other News for Differential Backup SQL Server 2017 brings several improvements to us. Sometimes a simple new field in a DMV can turn possible interesting... 02 June 2017 4 min read
