Showing posts with label Microsoft SQL Server. Show all posts
Showing posts with label Microsoft SQL Server. Show all posts
Wednesday, April 8, 2020

Data Science with SQL Server Machine Learning Services - YouTube Video

›
This video discusses performing data science experiments in SQL Server using Python. Setting up the environment, training, storing models a...
Friday, October 20, 2017

Azure Marketplace - SQL Server 2016 Virtual Machine - Data Tools cannot be installed

›
As you know, easiest way of getting a SQL Server set up in Azure is, purchasing a Virtual Machine in the Marketplace. There are multiple V...
Wednesday, July 20, 2016

Handout to Resolve SQL Server Connectivity Issues [Guest Post]

›
This post is written by Andrew Jackson . Problem Statement While launching Microsoft SQL Server Management Studio, sometimes user ...
Friday, November 27, 2015

Microsoft SQL Server Code Names for versions and features

›
Microsoft SQL Server team used/uses various code names for SQL Server versions and some of its features, here are some of them found in ...
Sunday, July 12, 2015

SQL Server: Locking cost, concurrency cost and concurrency issues [Discussion on Transactions - III]

›
Continuing notes related to the discussion.... Another area that was discussed is, how SQL Server places locks for transactions and wh...
Friday, July 10, 2015

Understanding SQL Server Recovery Process [Discussion on Transactions - II]

›
This is the continuation of the post I made: Understanding transaction properties with Microsoft SQL Server. During the same discussio...
Tuesday, July 7, 2015

Understanding transaction properties with Microsoft SQL Server [Discussion on Transactions - I]

›
I had a chance to discuss an old topic with few of my colleagues, it was on transactions and isolation levels. Although it is old, well kn...
Thursday, March 5, 2015

How to load/insert large amount of data efficiently

›
Importing data from other sources is a very common operation with most of database solutions as not all data cannot be entered row-by-row....
Monday, March 2, 2015

Free Microsoft SQL Server preparation courses at Virtual Academy for exams 464 and 465

›
Microsoft Virtual Academy has added two new preparation courses for SQL Server exams. Theses two courses cover  Developing Microsoft SQL S...
Sunday, March 1, 2015

SQL Server Brain Basher of the Week #001

›
I have been doing a series of session called SQL Server Brain Basher in SQL Server Sri Lanka User Group  ( https://www.facebook.com/group...
Saturday, February 28, 2015

How to stop users seeing all databases by default

›
Here is the scenario. You have created a login called "Jane" and have not added to any server role. And you are 100% sure that sh...
Friday, February 27, 2015

SQL Server Security Concepts: Securables, Pricipals and Permissions

›
When discussing and learning security related to SQL Server, it is always better to know the key concepts and terms related to it. Some of...
Tuesday, February 24, 2015

Gartner Magic Quadrant 2015 for Business Intelligence and Analytics Platforms is published

›
Gartner has released its Magic Quadrant for Business Intelligence and Analytics platforms for 2015. Just like the 2014 one, this shows bus...