SQL Repository
  • Home
  • Articles
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Code Snippets
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Interview Questions
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • How To
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Contact


Posts by Author [ davejenkins ]

Leading Zeros

On 04 Oct, 2015
T-SQL
By : Dave Jenkins
No Comments

I was recently asked to append some leading zeros to a column in a data set. I found one solution which was quick and simple....
Read More

WhoIsActive

On 13 Jun, 2015
MS SQL DBA
By : Dave Jenkins
No Comments

I thought that I would just share a little stored procedure that I've been using in my day job since becoming an accidental DBA! It's the WhoIsActive stored procedure by Adam Machanic. This stored procedure pulls together ALOT of information...

Read More

Index Rebuild or Index Reorganize

On 04 Jun, 2015
MS SQL DBA
By : Dave Jenkins
No Comments

You've just discovered that your indexes are fragmented, so you decid to do something about it. You know you need to do something to your indexes, but you're stuck wondering what the difference is between REBUILD and REORGANIZE.
...

Read More

T-SQL Divide by Zero Error

On 31 May, 2015
T-SQL
By : Dave Jenkins
No Comments

Someone in my day job this week asked me how to deal with Msg 8134, Level 16, State 1, Line 3 Divide by zero error encountered error that they were receiving. It's second nature for me to add the below...

Read More

How to find the expiry date for SQL Server 2012 Evaluation

On 30 May, 2015
T-SQL
By : Dave Jenkins
No Comments

Did you install SQL Server 2012 Standard Edition for evaluation purposes on your PC and forgot to write down when your six months is up? Yep, you're right, I'm talking from experience here! So I needed some T-SQL magic to...

Read More

Beginning SSRS – Part 3 Datasources and Datasets

On 25 May, 2015
SSRS
By : Dave Jenkins
No Comments

The third part of our Beginning SSRS series. An important lesson covering the embedded and shared datasources and datasets, as these are the bedrock for all...

Read More

Beginning SSRS – Part 2 Basic expressions / Conditional Formatting

On 24 May, 2015
SSRS
By : Dave Jenkins
No Comments

This is the second video in our Beginning SSRS Series. In this video we show you how to carry out basic expressions to change font colours, font weights, alternating row...

Read More

Beginning SSRS PT 1 – Our first report

On 19 May, 2015
SSRS
By : Dave Jenkins
No Comments

This is the first video in a series entitled "Beginning SSRS" - we are going to show you how to start with the basics of SSRS and work our way through to more advanced SSRS topics. If you want to...

Read More

Dynamic date range based on todays date

On 17 May, 2015
T-SQL
By : Dave Jenkins
No Comments

I had the challenge of putting together a T-SQL statement that's going to be used in a few stored procedures. The stored procedures will build data based on what todays date is, if today is greater than second Tuesday of...

Read More

Installing AdventureWorks 2012 & Chinook databases

On 14 May, 2015
MS SQL DBA
By : Dave Jenkins
No Comments

Here's a little video on installing the AdventureWorks 2012 & Chinook databases, we're going to be using them in future videos. The video is intended for new SQL Developers or DBA's that haven't had much experience in installing databases before. Read More


  • Page 1 of 3
  • 1
  • 2
  • 3


  • Popular
  • Recent
  • Database stuck in “Restoring” state

    17739 views
  • Find the modified date of SQL Server Agents Jobs

    8529 views
  • Script to Check TempDB Speed

    4693 views
  • PING all the Linked Servers and get a status report

    4364 views
  • Log shipping Alerts failing to send emails

    4229 views
  • Moving the tempdb database

    27 Jan, 2016
  • Script to Check TempDB Speed

    14 Jan, 2016
  • SQL Server buffer pool

    05 Nov, 2015
  • Log shipping Alerts failing to send emails

    04 Nov, 2015
  • View queries waiting for memory grant

    21 Oct, 2015

Useful links

  • Books Online for SQL Server 2012
  • Developer Reference for SQL Server 2014
  • Download SQL Server
  • Installation for SQL Server 2012
  • Microsoft Virtual Academy
  • SQL Server Online Training
  • Transact-SQL Reference
  • Tutorials for SQL Server 2012

Tags

.CSV 70-461 AdventureWorks 2012 ALL ANY CAST Chinook Database Code Snippet CONVERT CTE dataset datasource Dates DATETIME divide by zero Duplicates Exam EXCEPT expressions FORMAT IF Import Indexes INTERSECT Jobs NULLIF REBUILD Recursive CTE REORGANIZE ROW_NUMBER() Schedules Sequence SOME sp_stop_job SQL Server 2012 SQL Server Agent SSIS SSRS T-SQL Tally Table T_SQL UAC Permissions Error UNION UNION ALL

Recent Comments

  • Rudnei Silva on Log shipping Alerts failing to send emails
  • johnson Welch on Database stuck in “Restoring” state
  • Neil on Database stuck in “Restoring” state
  • Mark Gribler on MS SQL Database Administrator Interview Questions – Part 4

Google Analytics Stats

Latest Tweets:

  • 6 years ago Attended @SQLSatMcr yesterday - it was amazing! Roll on @sqlsatcambs! Won some Beats Headphones courtesy of @SQLDBApros - thanks guys! :)
  • 6 years ago Looking forward to attending @SQLSatMcr - its too far off though!!!
  • 6 years ago Simple Post: WhoIsActive SPROC: http://t.co/LZvQUaeapK
  • 6 years ago POST: Index REBUILD or Index REORGANIZE: http://t.co/h3L0N37vw4
  • 6 years ago How to Ping all Linked Servers: http://t.co/Q2QxusrKjO
  • 6 years ago For beginners - T-SQL Divide by Zero Error: http://t.co/BBhgoH5hK9

© Copyright 2015 SQL Repository. All Rights Reserved by SQL Repository