SQL Server Education (by the geeks, for the geeks)
Microsoft acquired Revolution Analytics in 2015 and integrated R in SQL Server 2016.Today I will show you how to install, configure and run R script in SSMS. Like all other Microsoft …
Read MoreData Security in any application is vital. Different business or application has their own security policy. SQL Server 2016 provides three new security features which helps to protect data. Below there …
Read MoreGreat start by DataPlatformGeeks team. On 26th January 2017, #DPS2017 is globally launched here and just after that on 28th January 2017 DPG team had a successful full day Data Platform Day event. …
Read MoreUsing FormatMessage function you can construct a message string located in sys.messages. The functionality of FORMATMESSAGE is very much same as RAISERROR statement. FORMATMESSAGE functions edits the message by substituting the …
Read MoreWhile debugging one procedure I came across below Scenario where a sub-query was returning all records from outer query. CREATE TABLE TABLE1 (COL1 INT IDENTITY ) GO INSERT INTO TABLE1 DEFAULT …
Read MoreIn this blog we’ll find how SQL Server works when we do join operation. SQL Server optimizer chooses one of the below physical operator to perform logical join operation. Hash Match …
Read MoreI got the below email from one of my teammate on ISDATE() function. Thanks to him for asking me the question. I do not have any idea on this behaviour of …
Read MoreThis feature was introduced in SQL Server 2012. Using With Result Sets option with Execute Command we can change the column name and data type of returning result set. Ex: Use TempDB Go …
Read MoreTo know about a topic we usually ask questions. Here I used the same method to explain about trace flags of SQL Server. Below are some basic questions and its answers …
Read MoreSSMS provides functionality to generate script for database objects. I’ve seen developer use this functionality to generate script for various objects like Tables, Procedures, Triggers and other database objects but after …
Read More