BI Robert Sheldon in BI SQL Server Machine Learning Services – Part 2: Python Data Frames SQL Server Machine Learning Services provides the ability to run Python scripts directly against data in SQL Server. To do... 18 December 2017 28 min read
Blogs John Paul Cook in Blogs Troubleshooting Failed PolyBase Installation in SQL Server 2017 This article shows you how to troubleshoot a failed installation of SQL Server and how to implement a workaround to... 12 December 2017 4 min read
BI Robert Sheldon in BI SQL Server Machine Learning Services – Part 1: Python Basics Python is a very popular language used for many purposes including machine learning. SQL Server 2017 supports Python with its... 30 November 2017 20 min read
Database Administration Robert Sheldon in Database Administration Still More SQL Server Features that Time Forgot As the final entry in this series, Robert Sheldon leads you through a group of forgotten features that have been... 17 November 2017 15 min read
T-SQL Programming Alfonso Hernandez in T-SQL Programming Summarizing Data Using the GROUPING SETS Operator Writing aggregate queries is one of the most important tasks for anyone working with T-SQL. Determining the expressions required in... 14 November 2017 9 min read
Database Administration Dennes Torres in Database Administration Checking SQL Server with Policy-Based Management Policy-Based Management, a feature of SQL Server, is a flexible tool that can help DBAs manage one or more SQL... 09 November 2017 15 min read
BI Robert Sheldon in BI SQL Server R Services: Working with Multiple Data Sets Although it is easy to use SQL Server R Services to create R scripts that incorporate SQL Server data by... 03 November 2017 19 min read
T-SQL Programming Phil Factor in T-SQL Programming Importing JSON Data from Web Services and Applications into SQL Server To support many applications, it makes sense for the database to work with JSON data, because it is the built-in... 27 October 2017 21 min read
Database Administration Dennes Torres in Database Administration Extended Events Profiler (XE Profiler) in SSMS Starting in SSMS version 17.3, we have an interesting new feature: Extended Events Profiler (XE Profiler). This new feature is in... 20 October 2017 2 min read
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
Containers and Virtualization Anand Joshi Yogesh Bhate in Containers and Virtualization Overcoming the Challenges of Microservices and Docker Containerisation A microservice architecture can provide great benefits to certain types of applications that have pronounced troughs and peaks in demand,... 19 September 2017 22 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
