Profile cover photo
Profile photo
Slava Murygin
46 followers
46 followers
About
Posts

Post has attachment
SQL Train Experience
Sorry for being late with this post. Just have to recap from the PASS Summit 2017. Here I'll briefly talk about SQL Train Experience. The organizer of the event Chris Hyde has already published a blog about it I'm just want to post my pictures and briefly d...
Add a comment...

Post has attachment
Giving special rights for group or user
SQL Server provides great flexibility for different types of security solutions. In this post I want to show one of them. Problem description: 1. Need to create a group/user "User1", which has to have only CRUD (Create-Read-Update-Delete) permissions for da...
Add a comment...

Post has attachment
Unique experience witnessing Total Solar Eclipse 2017
Add a comment...

Post has attachment
Drawing SQL Sphere
<= Drawing 3D Cube Couple of years ago I came up with an algorithm of drawing an ellipse using SQL Server spatial geometry:  http://slavasql.blogspot.com/2015/02/drawing-ellipse-in-ssms.html I've used that algorithm to make a sphere and as in my previous bl...
Add a comment...

Post has attachment
Drawing SQL Cubes
Hey, there is a time to go level up and instead of drawing Spirals, Fractals and other cool stuff I decided to go 3D! So, the first my try will be drawing 3D cubes. As you know, SQL is not an Object Orienting Programming language, and I can't just simply cr...
Add a comment...

Post has attachment
Drawing spirals with spatial data.
I do not know how to Google right and I couldn't find any blog showing how to draw a spirals using SQL Server spatial data. So, had to do it myself and sharing it with everybody. At first, here is the simple spiral DECLARE @i INT = 0 , @R FLOAT = 0 , @Angle...
Add a comment...

Post has attachment
Challenging SQL Server precision with Pi calculations.
Sometimes it is interesting just to play with SQL Server and hit its limits. This time I've had some fun with getting closer to "Pi". You might ask: -Why??? We have wonderful Pi() function; If we need bigger precision, we can always get this number with up ...
Add a comment...

Post has attachment
SQL Databases. Everything you need to know about them.
This post is about all currently available queries associated with "SQL Databases" functionalities assigned to "Ctrl+5" keyboard shortcut in SSMS (SQL Server management studio). I'll uncover internals and hidden features of "Ctrl+5" shortcut. You can downlo...
Add a comment...

Post has attachment
Read all files of SQL Server's drive in a Tree using recursive CTE
In this blog I'll use undocumented in SQL Server extended stored procedure " xp_dirtree ". That procedure is well described in Patrick Keisler's blog . Briefly, " xp_dirtree " extended procedure returns tree of sub-directories from given folder and has thre...
Add a comment...

Post has attachment
SQL Server on Linux: Specifying File Path. Possible problems.
NOTE: Please be aware that all scripts work only as of publishing date and with SQL Server on Linux CTP 1.4. In future releases some features/bugs may disappear. As you might know Linux file system is different from Windows. Linux does not have drive letter...
Add a comment...
Wait while more posts are being loaded