T-SQL Programming Joe Celko in T-SQL Programming Simple SQL: Handling Location Datatypes How do you record locations in SQL? Most relational database systems support spatial and geographical data, generally using the round-earth... 19 October 2017 14 min read
Laerte Junior Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask Can you imagine it? You are in a group of smart database people, and they are debating the finer points... 18 October 2017 9 min read
Database Administration Robert Sheldon in Database Administration Even More SQL Server Features that Time Forgot SQL Server works well, and Microsoft does everything it can to keep it relevant and competitive: As with everything in... 18 October 2017 13 min read
Blogs Dennes Torres in Blogs Easy way to create policies using SSMS SSMS has an interesting feature that turns easy the creation of policies to check our servers compliance. Right-clicking an item... 09 October 2017 2 min read
BI Robert Sheldon in BI SQL Server R Services: Generating Sparklines and Other Types of Spark Graphs By being able to run R from SQL Server, you have available to you not just a convenient way of... 04 October 2017 15 min read
Blogs Dennes Torres in Blogs Monitoring SQL Server with Power BI Query Store is becoming more and more important for server monitoring, specially in SQL Server 2017, which allows us to... 04 October 2017 2 min read
Database Administration Robert Sheldon in Database Administration More SQL Server Features that Time Forgot SQL Server produces some great features, but it would be impossible to get them spot-on target every time. We are... 20 September 2017 14 min read
Laerte Junior Questions About RDS SQL Server That You Were Too Shy to Ask There are a number of different ways that you can host SQL Server. RDS SQL Server, for example, uses SQL... 13 September 2017 12 min read
Blogs Phil Factor in Blogs Consuming hierarchical JSON documents in SQL Server using OpenJSON Over the years, Phil was struck by the problems of reading and writing JSON documents with SQL Server, and wrote... 12 September 2017 13 min read
Dennes Torres How much should you worry about CXPACKET? Several experts already wrote about CXPACKET before, there are plenty of articles about this subject on the internet, so, why... 11 September 2017 3 min read
T-SQL Programming Joe Celko in T-SQL Programming Missing Data In the real world of business or scientific reporting and analysis, data can prove to be awkward. It can be... 08 September 2017 11 min read
Database Administration Brent Ozar in Database Administration Six Scary SQL Surprises The working life of the DBA can be punctuated by surprises, but they aren't generally nice surprises. This is especially... 06 September 2017 24 min read
BI Robert Sheldon in BI SQL Server R Services: Working with Data Frames Although you can get started with R in SQL Server without understanding data frames, they are a key structure of... 06 September 2017 29 min read
Dennes Torres Thoughts about submitting a new Power BI Quick Measure ‘Quick Measures’ is a feature included in Power BI Desktop April update. It’s still in preview, so you need to... 25 August 2017 5 min read
.NET Dan Turner in .NET Why is My Database Application so Slow? When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that... 24 August 2017 14 min read
Opinion Pieces Robert Sheldon in Opinion Pieces The SQL Server Features that Time Forgot Every new release of SQL Server comes with new features that cause a ripple of excitement within the industry: well,... 23 August 2017 12 min read
T-SQL Programming Joe Celko in T-SQL Programming Simple SQL: Random Thoughts How does one get a truly random sample of data of a certain size from a SQL Server database table.... 11 August 2017 9 min read
BI Robert Sheldon in BI SQL Server R Services: Working with ggplot2 Statistical Graphics It is when you use R in SQL Server with one of the huge range of packages that comes with... 11 August 2017 21 min read
Blogs Dennes Torres in Blogs Monitoring UnmatchedIndexes Warning If you are using filtered indexes in SQL Server, it worthwhile monitoring the UnmatchedIndexes warning, it can give us very... 07 August 2017 4 min read
T-SQL Programming Hitendra Patel in T-SQL Programming The Power of Python and SQL Server 2017 Python is new to SQL Server 2017. It is intended primarily to allow the use of Python-based machine-learning within SQL... 04 August 2017 14 min read