Bravin Wasike

test

teatasetstsetsts etsetsetsets link werwerewr…

24 August 2020 1 min read

Blogs

Louis Davidson in Blogs

Trigger Validations and Isolation Levels

Writing data integrity code in TRIGGER objects is generally is pretty simple. Typically you write a query to see “is...

18 August 2020 9 min read

BI

Sanil Mhatre in BI

Sentiment Analysis and Text Mining with R: Word Clouds, NRC Lexicon, and Scores

Text mining and sentiment analysis with R: install the tm package, clean text data, build term-document matrices, generate word clouds,...

13 May 2020 20 min read

Blogs

Annette Allen in Blogs

Isn’t the technical Community great?!!

With everything that’s been going on in the world recently and all events being cancelled or postponed you might mistakenly...

07 May 2020 4 min read

Blogs

Phil Factor in Blogs

Tackling Imperial and US Customary Measurements in Databases

The old measurements of length, area, volume and weight in the UK and the States refuse to die. They are...

06 May 2020 10 min read

Blogs

Louis Davidson in Blogs

SQL Agent Job Generator: Scheduling A Job

In this last entry in the initial series of posts on building a SQL Agent Job Generator, I am going...

17 April 2020 10 min read

Blogs

Dennes Torres in Blogs

Identity column vs ETL Process

Creating ETL process can pose so many challenges we will only fully discover them when really building the ETL. Before...

01 March 2020 6 min read

Blogs

Louis Davidson in Blogs

Mixing Relational and Graph DB Objects (Book and Session Prep)

Graph structures are something that I have lightly covered in my Database Design book in the last few book editions...

27 February 2020 5 min read

Blogs

Phil Factor in Blogs

Copying of all data between SQL Server databases and servers

This script will copy out all the tables from one version of a database in native BCP format, and place...

31 January 2020 7 min read

Louis Davidson

Happy New Year’s Resolutions

This has been quite a year, which is why this year’s resolutions are not in October as had been my...

01 January 2020 7 min read

Blogs

Phil Factor in Blogs

Managing SQL Server Documentation as JSON: Per-Object Extracts, MongoDB Tooling, and Collective Editing

An alternative approach to SQL Server database documentation: extract each object's metadata (tables, routines, columns, indexes) as individual JSON files,...

03 December 2019 11 min read

Blogs

Phil Factor in Blogs

What’s in that database? Getting information about routines

There is a lot of information held in SQL Server metadata about your SQL Server procedures, triggers, views and functions....

04 November 2019 18 min read

Darko Martinović

Programming SQL Server with SQL Server Management Objects Framework

SQL Server Management Objects (SMO) is a great tool for managing SQL Server. Darko Martinovic demonstrates how to use SMO...

09 April 2018 26 min read

.NET

Darko Martinović in .NET

Transposing SQL Server Query Results with SQLCLR: Dynamic Row-to-Column Rotation

Transpose SQL Server query results dynamically using a SQLCLR stored procedure - no need to know column names in advance....

13 March 2018 18 min read

Bud Aaron

How to set up a database-driven Azure site

So how easy is it to set up a database-driven application on Azure, using the tools that one is familar...

26 April 2012 12 min read

Register for Simple Talk

Uncategorized

test

Trigger Validations and Isolation Levels

Sentiment Analysis and Text Mining with R: Word Clouds, NRC Lexicon, and Scores

Isn’t the technical Community great?!!

Tackling Imperial and US Customary Measurements in Databases

SQL Agent Job Generator: Scheduling A Job

Identity column vs ETL Process

Mixing Relational and Graph DB Objects (Book and Session Prep)

Copying of all data between SQL Server databases and servers

Happy New Year’s Resolutions

Managing SQL Server Documentation as JSON: Per-Object Extracts, MongoDB Tooling, and Collective Editing

What’s in that database? Getting information about routines

Programming SQL Server with SQL Server Management Objects Framework

Transposing SQL Server Query Results with SQLCLR: Dynamic Row-to-Column Rotation

How to set up a database-driven Azure site