DotNetShoutout - Stories tagged with SQL Server

SQL Server

atom rss
7
Shouts
spam Shout it Mute it

Identity column with decimal datatype
published 468 days, 7 hours, 24 minutes ago posted by dharadhara 471 days, 9 hours, 27 minutes ago
Thursday, February 09, 2012 10:15:54 PM GMT Monday, February 06, 2012 8:12:20 PM GMT
One of the members in the forum asked about using decimal datatype in identity column. The question was "Is decimal point allowed in the identity column?" Ok. The identity column can never have any decimal points. It is a whole number. The decimal... (more)
category: Data | clicked: 9 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

#0130 - SQL Server – SSMS – Tutorial – Part 05 – The Wizards of SSMS - Table Designer, Query designer & Template Explorer (L100)
published 468 days, 7 hours, 24 minutes ago posted by dharadhara 471 days, 9 hours, 28 minutes ago
Thursday, February 09, 2012 10:15:54 PM GMT Monday, February 06, 2012 8:11:51 PM GMT
The SQL Server Management Studio is truly an Integrated Development Environment. There are utilities, tools and graphical designers available within SSMS which are useful to audiences of multiple levels. The graphical designers are a set of utilities... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, ssms
8
Shouts
spam Shout it Mute it

Getting started with SSIS - Getting started with SSIS - Part 1: Introduction to SSIS - Sudeep Raj
published 468 days, 7 hours, 24 minutes ago posted by dharadhara 471 days, 9 hours, 28 minutes ago
Thursday, February 09, 2012 10:15:54 PM GMT Monday, February 06, 2012 8:11:25 PM GMT
SSIS is a tool used for ETL. Before we talk on SSIS, let me walk you through what is ETL. ETL stands for Extract Transform and Load. These are simple day-to-day words we use in our daily lives. The figure below depicts ETL in real world scenario. (more)
category: Data | clicked: 14 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
6
Shouts
spam Shout it Mute it

Generate test data using DBGen
published 468 days, 7 hours, 24 minutes ago posted by dharadhara 473 days, 10 hours, 22 minutes ago
Thursday, February 09, 2012 10:15:54 PM GMT Saturday, February 04, 2012 7:17:37 PM GMT
Over the last couple of months I have on several occasions found myself in need of test data for demos, blogposts etc. You all know AdventureWorks, which will work for a lot of demoing stuff. But the amount of data is limited, and if you are demoing stuff... (more)
category: Data | clicked: 33 | 2 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Error encountered in SQL Server - Alter failed for Login sa. Cannot set a credential for principal 'sa'.
published 471 days, 11 hours, 17 minutes ago posted by dharadhara 473 days, 10 hours, 22 minutes ago
Monday, February 06, 2012 6:22:29 PM GMT Saturday, February 04, 2012 7:17:15 PM GMT
Recently when i worked with SQL Server security, i encountered with one error while trying to modify 'SA' account properties. The exception details looks following, Alter failed for Login sa. Cannot set a credential for principal 'sa'... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Stored Procedure to Get Expensive Queries
published 471 days, 11 hours, 17 minutes ago posted by dharadhara 474 days, 10 hours, 26 minutes ago
Monday, February 06, 2012 6:22:29 PM GMT Friday, February 03, 2012 7:13:41 PM GMT
As a DBA we often need to get information on various Queries, One of them is how expensive it is. A query can be judged as expensive on various criteria’s like Long Running, Memory Utilization, CPU utilization etc. I came up with this Stored Procedure... (more)
category: Data | clicked: 21 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Stored Procedure to Purge MSDB Job History
published 471 days, 11 hours, 17 minutes ago posted by dharadhara 474 days, 10 hours, 26 minutes ago
Monday, February 06, 2012 6:22:29 PM GMT Friday, February 03, 2012 7:13:21 PM GMT
Purging your MSDB Job History is sometime very important which helps you read the Jos history in GUI very easily and keeps which only required number of days. You can add this in your Maintenance Plan or using a SSIS Package. I found one of the way a... (more)
category: Data | clicked: 8 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Using TraceEvent for MDX Debugging
published 471 days, 11 hours, 17 minutes ago posted by dharadhara 474 days, 10 hours, 27 minutes ago
Monday, February 06, 2012 6:22:29 PM GMT Friday, February 03, 2012 7:12:43 PM GMT
Do you know how it feels like to hear an old song and have a whole lot of memories come flooding back to you? Well, something sort of similar happened to me today. I was doing my weekly reading and going through a brilliant post by Microsoft MVP - Greg... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

#0129 - SQL Server – SSMS – Tutorial – Part 04 – Introduction to Database Diagramming (L100)
published 471 days, 11 hours, 17 minutes ago posted by dharadhara 475 days, 10 hours, 22 minutes ago
Monday, February 06, 2012 6:22:29 PM GMT Thursday, February 02, 2012 7:17:11 PM GMT
For those who have worked in Enterprise environments, documentation is of utmost importance. Documentation can be in the form of a text-based document, or a graphical document (in the form of a diagram). A data dictionary is a centralized repository of... (more)
category: Data | clicked: 15 | comment | | source: beyondrelational.com
tags: SQL Server, ssms, TSQL, BI
7
Shouts
spam Shout it Mute it

#0128 - SQL Server – SSMS – Tutorial – Part 03 – The T-SQL Debugger (L200)
published 471 days, 11 hours, 17 minutes ago posted by dharadhara 475 days, 10 hours, 23 minutes ago
Monday, February 06, 2012 6:22:29 PM GMT Thursday, February 02, 2012 7:16:21 PM GMT
More often than not, there is a myth in the developer community that Microsoft SQL Server does not provide the debugging abilities that other IDEs provide. Even SQL Server 2000 provided basic debugging ability. Starting Microsoft SQL Server 2005, the... (more)
category: Data | clicked: 28 | comment | | source: beyondrelational.com
tags: SQL Server, ssms
7
Shouts
spam Shout it Mute it

Working with Application Role - SQL Server
published 475 days, 12 hours, 33 minutes ago posted by dharadhara 476 days, 10 hours, 27 minutes ago
Thursday, February 02, 2012 5:06:51 PM GMT Wednesday, February 01, 2012 7:12:21 PM GMT
In last post we have seen custom database roles as how can we create it and assign required access to users. We also noticed that we can add multiple members with same role. That was the security with database roles and members comes into the picture... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

#0127 - SQL Server – SSMS – Tutorial – Part 02 – Introduction to the Object Explorer and Object Explorer Details window (L100)
published 475 days, 12 hours, 33 minutes ago posted by dharadhara 476 days, 10 hours, 28 minutes ago
Thursday, February 02, 2012 5:06:51 PM GMT Wednesday, February 01, 2012 7:12:02 PM GMT
As you know, we are exploring the world of graphical tools & utilities that are available to us out of the box in a Microsoft SQL Server installation. In the previous part of the tutorial, I provided an introduction to the SQL Server Management Studio... (more)
category: Data | clicked: 2 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

#0126 - SQL Server – SSMS – Tutorial – Part 01 – Introduction to the Management Studio and Query Editor (L100)
published 475 days, 12 hours, 33 minutes ago posted by dharadhara 477 days, 11 hours, 29 minutes ago
Thursday, February 02, 2012 5:06:51 PM GMT Tuesday, January 31, 2012 6:10:59 PM GMT
Per Books-On-Line, The Microsoft SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. The SQL Server Management Studio is an integrated environment for accessing, configuring, managing... (more)
category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Reducing SSRS RDL size by uploading Shapefiles to ReportServer
published 475 days, 12 hours, 33 minutes ago posted by dharadhara 477 days, 11 hours, 29 minutes ago
Thursday, February 02, 2012 5:06:51 PM GMT Tuesday, January 31, 2012 6:10:31 PM GMT
I don’t know about you guys, but I am really petrified of public speaking. So I always try to read about it and it really gives me some comfort to know that I am not alone. In fact, if your fear of public speaking is between mild anxiety and complete... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, SSRS
8
Shouts
spam Shout it Mute it

Knowing minimum timestamp value for a database
published 475 days, 12 hours, 33 minutes ago posted by dharadhara 477 days, 11 hours, 30 minutes ago
Thursday, February 02, 2012 5:06:51 PM GMT Tuesday, January 31, 2012 6:09:48 PM GMT
When a datatype timestamp or rowversion is used, it generates unique value whenever a row is added or updated in a table. It is one of the ways to generate auto-generated values not only for insertion but for updation too. If you want to know the minimum... (more)
category: Screencast | clicked: 51 | comment | | source: beyondrelational.com
tags: SQL Server, Database
7
Shouts
spam Shout it Mute it

DB2 security audit
published 475 days, 12 hours, 33 minutes ago posted by dharadhara 478 days, 10 hours, 41 minutes ago
Thursday, February 02, 2012 5:06:51 PM GMT Monday, January 30, 2012 6:59:04 PM GMT
The SYSIBM.SYSDBAUTH maintains user privileges on databases The SYSIBM.SYSPLANAUTH maintains user privileges on plans The SYSIBM.SYSUSERAUTH maintain user privileges on the system. This shell script collects and records these recordsets. Useful for regular... (more)
category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Database
8
Shouts
spam Shout it Mute it

SQL Server Page Restore
published 475 days, 12 hours, 33 minutes ago posted by dharadhara 478 days, 10 hours, 41 minutes ago
Thursday, February 02, 2012 5:06:51 PM GMT Monday, January 30, 2012 6:58:37 PM GMT
We all know how backup is important. I usually say that restore is more important than backup. We can create backup but if we don’t know how to restore it, or we cannot because it isn’t correct we have nothing. So always check your backups and restore... (more)
category: Data | clicked: 16 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

SQL Server Index Fragmentation Script
published 475 days, 12 hours, 33 minutes ago posted by dharadhara 478 days, 10 hours, 42 minutes ago
Thursday, February 02, 2012 5:06:51 PM GMT Monday, January 30, 2012 6:58:03 PM GMT
Just sharing a cool script I stumbled across while searching for SQL Server index fragmentation scripts ( Omer van Kloeten's Blog ). I’ve cleaned it up a bit and turned it into a Stored Procedure so that I can execute it as a SQL Server Agent... (more)
category: Data | clicked: 39 | 2 comments | | source: beyondrelational.com
tags: SQL Server, index
3
Shouts
spam Shout it Mute it

A SQL Server Leap Year Test Function
published 478 days, 20 hours, 57 minutes ago posted by BlackWaspBlackWasp 479 days, 6 hours, 44 minutes ago
Monday, January 30, 2012 8:42:23 AM GMT Sunday, January 29, 2012 10:55:49 PM GMT
Transact-SQL does not provide a standard function that allows developers to determine if a year is a leap year. This article describes two functions. One to calculate the number of days in a year and one that utilises the result to identify leap years. (more)
category: Data | clicked: 6 | comment | | source: www.blackwasp.co.uk
tags: SQL Server
7
Shouts
spam Shout it Mute it

SQL Server - Custom Database Role
published 477 days, 18 hours, 25 minutes ago posted by dharadhara 480 days, 10 hours, 25 minutes ago
Tuesday, January 31, 2012 11:14:37 AM GMT Saturday, January 28, 2012 7:14:52 PM GMT
Recently while working with database security, I learned database roles as how the each role used. Apart from the server level roles if we need to require to assign access/rights to particular databases level then we need to go through database level... (more)
category: Data | clicked: 7 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
Previous 1 2 3 4 5 6 7 8 9 10 ... 43 44 Next