Tags » SQLSERVER

Data types

Data types and Precedence of convert types

SQL Server associates columns, expressions, variables, and parameters with data types. Data types determine what kind of data can be stored in the field: Integers, characters, dates, money, binary strings, etc. 131 more words

Database

Storage - Part I

Pages and Extends Architecture

The page is the fundamental unit of data storage in SQL Server. An extent is a collection of eight physically contiguous pages. 303 more words

Database

Case Insensitive Lookups with SSIS

Whilst recently compiling a reasonably complex transformation to bring in some data from an Excel spreadsheet I was left in the situation where I had a some look ups that were failing to resolve due to case sensitivity. 385 more words

Technical

Finding Start and End dates using TSQL

On the 15th, October I attended SQL Relay in Bristol and amongst all of the great content Dave Morrison TSLQNINJA showed us a nifty way of finding the end dates of a year (or month or week) using TSQL. 156 more words

Sqlserver

Exploiting MS SQL Server: Fast-Track, mssql_ping, mssql_login, mssql_payload, Meterpreter Shell

The exploitee system comprises: Windows XP Pro Service Pack 2 (unpatched). Firewall and software updates switched off, Microsoft Internet Information Services (IIS) (server) and FTP service enabled, SQL Server 2005 Express configured, and a vulnerable web app up and running. 371 more words

Penetration Testing

#0349 – SQL Server – SSMS Usability - Unable to Show XML, Unexpected End of File when parsing

Today’s post comes from a recent experience. I was trying to extract an XML from one of the logs that we maintain in the application when exchanging data over an interface. 217 more words

#SQLServer

The Question - Why?

The question I get asked a lot by other data professionals at conferences, events, speaking engagements, family, friends, etc. is Why do you do what you do?  1,538 more words

SQLServerPedia Syndication