Tags » SQLSERVER

Getting SQL Server for Practice & Learning Purposes - Preliminaries

I’m now plunged into my MTA course and learning the theory. So far so good.

I’m though bumping into my first techie challenge: getting SQL Server on my computer… 287 more words

Databases

Convert a string into Title case in Sqlserver

Input: This is test input data!

output: This Is Test Input Data!

CREATE FUNCTION funTitleCase
(
@str VARCHAR(1000)
)
RETURNS VARCHAR(1000)
AS
BEGIN
DECLARE @counter INT = 0, @length INT = 0;

45 more words
Substring

Wait Statistics: the Basis for Troubleshooting

One of the first items that needs to be checked when troubleshooting performance problems on a SQL Server, is the wait statistics.

We can capture this information from a DMV sys.dm_os_wait_stats. 348 more words

Wednesday Fun Fact #1

Woah! Really? Like Sheldon Cooper’s Fun with Flags, but more or less useful for the SQL Server DBA or System Admin. You decide.

This week Erik Darling at… 76 more words

Some fancy BI stuff: SSIS training, Data Tools add-ins and BIML academy

A few days ago I posted a link to one BIML introduction webcast. Now I now it will be a series of webcasts this week, it’s a great oportunity to learn more about it! 354 more words

SQLServer

Introduction to SQL

The world of programming is vast, there are many different languages to learn. But some of these languages are considered most valuable in workplaces. Starting with… 342 more words