Tags » SQL

Sprawdzanie błędów SQL

Technika pewnie dla wielu znana, ale może nie dla wszystkich. 91 more words


Data Type

.We need data type to defined Column, local variable, expression, and parameters
.An attribute that specifies the type of data(integer, characters, money and so on) that the object can hold. 365 more words


Interview Question of the Week #004 - List All Columns and Their Data Type for a View

Earlier this week I wrote a blog about finding stored procedure parameters and their data types. After that blog I received few emails from my blog readers asking for similar script for a view. 921 more words

SQL Authority

Amazon Redshift - How to get the sizes of all tables

This is another useful script, in the series of Redshift related tools and scripts that I find very useful. The following query gives you all tables and their row count and disk size on a given database in Redshift cluster. 195 more words


Speaking at Nebraska Code Conference in March

I’ll be speaking at the Nebraska Code Conference in March and I’ll be talking Trend Reporting Using PowerShell and SQL. This will be my first in person speaking gig at a conference so I am both excited and a little nervous about it but definitely looking forward to talking about PowerShell and showing something cool in the process. 39 more words


SQL SERVER - How to Bind Resource Governor for InMemory Enabled Databases?

I have done a number of courses for Pluralsight. Last year when SQL Server 2014 was released, I planned to do a session on the same. 742 more words

SQL Authority