SqlServerKudos - Latest published stories in Management

Management

atom rss
1
kudos
spam Kudos Remove

Ebay Suppliers
published 41 days, 7 hours, 44 minutes ago posted by kishangkishang 51 days, 7 hours, 36 minutes ago
Sunday, June 20, 2010 12:21:33 PM GMT Thursday, June 10, 2010 12:29:53 PM GMT
Ebay Suppliers
Shopster offers a complete ecommerce solution that allows dropshippers & suppliers to sell online successfully. Free Join Now! (more)
category: Management | clicked: 0 | comment | | source: www.shopster.com
tags: dropshippers, dropshipping
1
kudos
spam Kudos Remove

Ductless Air Conditioner
published 45 days, 8 hours, 4 minutes ago posted by kishangkishang 54 days, 9 hours, 54 minutes ago
Wednesday, June 16, 2010 12:01:47 PM GMT Monday, June 07, 2010 10:11:21 AM GMT
Ductless Air Conditioner
Shipping the most reliable ductless mini split air conditioners product is easy at HeatandCool.com (more)
category: Management | clicked: 0 | comment | | source: www.heatandcool.com
1
kudos
spam Kudos Remove

Calculating ROI on Performance Tuning - Never Say Never
published 45 days, 8 hours, 4 minutes ago posted by jacobsebastianjacobsebastian 54 days, 14 hours, 26 minutes ago
Wednesday, June 16, 2010 12:01:47 PM GMT Monday, June 07, 2010 5:39:52 AM GMT
Calculating ROI on Performance Tuning - Never Say Never
Recently on the SSC forums, someone asked about how to measure the money in an actual dollar figure that they have saved the company with their performance tuning. I've often struggled with this myself, and so I started thinking about it a bit deeper. I started to respond in the thread; then decided I was going to be a bit too long winded so I moved it here. The following are some of my thoughts/opinions on the subject. I think everyone will agree that it's probably not worth the time to optimize a ... (more)
category: Management | clicked: 2 | comment | | source: beyondrelational.com
tags: roi, SQLServer
1
kudos
spam Kudos Remove

Tips and Tricks to prevent SQL Injection in .Net Code - Deepak Palkar's Blog
published 59 days, 9 hours, 6 minutes ago posted by jacobsebastianjacobsebastian 66 days, 14 hours, 57 minutes ago
Wednesday, June 02, 2010 10:59:41 AM GMT Wednesday, May 26, 2010 5:08:53 AM GMT
Tips and Tricks to prevent SQL Injection in .Net Code - Deepak Palkar's Blog
SQL Injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing and execution. This can allow an attacker to steal the data as well as modify and delete it. Conventional security measures like use of SSL and IPSec, do not protect the application from SQL injection attacks. (more)
category: Management | clicked: 2 | comment | | source: beyondrelational.com
1
kudos
spam Kudos Remove

Whitepaper: Master Data Management from a Business Perspective - SQL Server White Papers
published 68 days, 9 hours, 44 minutes ago posted by jacobsebastianjacobsebastian 77 days, 12 hours, 12 minutes ago
Monday, May 24, 2010 10:21:16 AM GMT Saturday, May 15, 2010 7:53:38 AM GMT
Whitepaper: Master Data Management from a Business Perspective - SQL Server White Papers
This article helps business stakeholders understand how to determine the master data management needs of their organization. After reading this article, business stakeholders should be empowered to define a high level vision for implementing a master data management solution within their organization. (more)
category: Management | clicked: 1 | comment | | source: beyondrelational.com
2
kudos
spam Kudos Remove

Post Upgrade Experience: SQL 2000 to 2008 - Never Say Never
published 75 days, 10 hours, 15 minutes ago posted by ashishgilhotraashishgilhotra 85 days, 7 hours ago
Monday, May 17, 2010 9:50:33 AM GMT Friday, May 07, 2010 1:05:32 PM GMT
Post Upgrade Experience: SQL 2000 to 2008 - Never Say Never
Whew! So I've been super busy the past week and a half upgrading our production server from SQL 2000 to SQL 2008 and haven't had time for any new posts. Finally starting to see everything calm down again though and running smoother than ever before. I had hoped to do a comparison of 2000 and 2008 disk activity pre and post compression, but due to the number of "emergencies" in the week prior to the changeover and the number of times our plans changed with reconfiguring raid arrays etc. I never had an opp... (more)
category: Management | clicked: 0 | comment | | source: beyondrelational.com
2
kudos
spam Kudos Remove

If you don’t know any thing of Indexes of your databases… - Dinesh Asanka
published 83 days, 10 hours, 49 minutes ago posted by jacobsebastianjacobsebastian 93 days, 7 hours, 51 minutes ago
Sunday, May 09, 2010 9:16:12 AM GMT Thursday, April 29, 2010 12:14:31 PM GMT
If you don’t know any thing of Indexes of your databases… - Dinesh Asanka
Having discuss indexes in some what details, this post will give some queries to get the index information of you databases. Ok, if you are a DBA, most of the time you need to manage some others databases. In my carrier, it is only few occasions where I was given task to design fresh database. All the other occasions, it is managing heritage databases, which you can’t avoid. (more)
category: Management | clicked: 5 | comment | | source: beyondrelational.com
1
kudos
spam Kudos Remove

SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database « Journey to SQL Authority with Pinal Dave
published 103 days, 12 hours, 21 minutes ago posted by pinaldavepinaldave 113 days, 10 hours, 8 minutes ago
Monday, April 19, 2010 7:44:46 AM GMT Friday, April 09, 2010 9:56:55 AM GMT
SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database « Journey to SQL Authority with Pinal Dave
I recently downloaded Idera’s SQL virtual database, and tested it. There are a few things about this tool which caught my attention. My Scenario It is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database backup was 40 GB in size, and, to restore it on our production server, it usually takes around 16 to 22 minutes, depending on the load server that is usually present. This range in time varies from one ser... (more)
category: Management | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

Rise of the SQL Server DevBA | AdaTheDev
published 138 days, 14 hours, 55 minutes ago posted by AdaTheDevAdaTheDev 148 days, 11 hours, 33 minutes ago
Monday, March 15, 2010 5:10:13 AM GMT Friday, March 05, 2010 8:31:57 AM GMT
Rise of the SQL Server DevBA | AdaTheDev
"DevBA" - an SQL Server Developer with a bit of DBA thrown in. As a developer, broadening your horizons to a DBA's mindset can offer great benefits and add to your skillset. (more)
category: Management | clicked: 3 | comment | | source: www.adathedev.co.uk
tags: DBA, Developer, SQLServer
1
kudos
spam Kudos Remove

Log et al – Peter Curd » Renaming Microsoft SQL Server servers and the effects on SPNs
published 141 days, 14 hours, 8 minutes ago posted by http://pcurd.co.uk/http://pcurd.co.uk/ 148 days, 20 hours, 8 minutes ago
Friday, March 12, 2010 5:57:11 AM GMT Thursday, March 04, 2010 11:57:47 PM GMT
Log et al – Peter Curd » Renaming Microsoft SQL Server servers and the effects on SPNs
Last week I saw a post on Simon Sabin’s blog about SQL Server service accounts and SPNs and made a comment about the importance of SPNs when renaming a SQL Server or migrating several servers into .. less than several. I felt this an area worth expanding a little more. (more)
category: Management | clicked: 1 | comment | | source: pcurd.co.uk
tags: Active Directory, Administration, SPN, SQL Server
1
kudos
spam Kudos Remove

Changing primary key index structure | AdaTheDev
published 144 days, 14 hours, 19 minutes ago posted by AdaTheDevAdaTheDev 152 days, 6 hours, 40 minutes ago
Tuesday, March 09, 2010 5:46:46 AM GMT Monday, March 01, 2010 1:25:24 PM GMT
Changing primary key index structure | AdaTheDev
Changing the structure of a primary key constraint index from nonclustered to clustered (or from clustered to nonclustered) is not necessarily as straight forward as it first seems. The process of changing it over, involves the constraint being dropped and then recreated. This could potentially cause a problem if you're making the change on a table whilst there could be activity against it. (more)
category: Management | clicked: 3 | comment | | source: www.adathedev.co.uk
tags: Indexes, SQL, SQLServer
1
kudos
spam Kudos Remove

Autogenerated SQL constraint names - why to avoid them | AdaTheDev
published 147 days, 14 hours, 33 minutes ago posted by AdaTheDevAdaTheDev 153 days, 21 hours, 4 minutes ago
Saturday, March 06, 2010 5:31:56 AM GMT Saturday, February 27, 2010 11:00:57 PM GMT
Autogenerated SQL constraint names - why to avoid them | AdaTheDev
Autogenerated constraint names in SQL Server - are they convenient, or are they a hindrance? For me, they are a hindrance. Why should I care that SQL Server autogenerates a constraint name when I don't explicitly specify one? Why does it matter if it names my PRIMARY KEY constraint "PKConstrai3214EC271FCDBCEB", or my DEFAULT constraint "DFConstraintColumnA__21B6055D"? This article explains reasons why you should specify a name yourself for each constraint. (more)
category: Management | clicked: 0 | comment | | source: www.adathedev.co.uk
tags: sqlserver database
1
kudos
spam Kudos Remove

Metaproblem: Drama
published 165 days, 15 hours, 51 minutes ago posted by sasa 172 days, 19 hours, 8 minutes ago
Tuesday, February 16, 2010 4:14:43 AM GMT Tuesday, February 09, 2010 12:57:53 AM GMT
Metaproblem: Drama
This post is an introduction to metaproblems and discusses a common metaproblem: drama. define a problem as an unsolved issue. It could be minor. Or it could threaten your project, llivelihood, or even your life. Problems share some characteristics: •Problems are not symptoms. •Problems are not effects. •Problems rarely scale. The symptoms of a problem are related to the problem. We usually think of symptoms medically. If you have a common cold you exhibit symptoms. The symptoms indicate you ha... (more)
category: Management | clicked: 0 | comment | | source: sqlblog.com
tags: EMPs (Expensive Management Practices), Software Business
1
kudos
spam Kudos Remove

DropDownList GridView and SelectedIndexChanged [ Visual Basic Knowledgebase ]
published 258 days, 1 hour, 44 minutes ago posted by ponssaravananponssaravanan 267 days, 4 hours, 34 minutes ago
Sunday, November 15, 2009 6:21:47 PM GMT Friday, November 06, 2009 3:31:11 PM GMT
DropDownList GridView and SelectedIndexChanged [ Visual Basic Knowledgebase ]
Please Wait... Visual Basic Knowledgebase   DropDownList GridView and SelectedIndexChanged This article is written by Pon Saravanan  on 01-Nov-09Last modified on :01-Nov-09 Using a DropDownList inside a GridView Dropdowns are one of the most used basic controls just like a textbox. This article explains how to have a DropDownList inside a GridView. Basically the dropdowns have the AutoPostBack property to have a PostBack while selecting items. This can happen in GridView... (more)
category: Management | clicked: 0 | comment | | source: www.vbknowledgebase.com
1
kudos
spam Kudos Remove

Zip Repair
published 261 days, 1 hour, 58 minutes ago posted by macsmith85macsmith85 270 days, 14 hours, 34 minutes ago
Thursday, November 12, 2009 6:06:57 PM GMT Tuesday, November 03, 2009 5:30:56 AM GMT
Zip Repair
Zip Repair Recovery Software repairs & recovers corrupted .zip files and restores the corrupted zip file to its original condition that don’t open or have lost data due to corruption. Stellar Phoenix Zip Recovery Software helps you recover corrupted Zip files after repairing the damage in the zip files. Stellar Phoenix Zip Recovery Software scans for the corruption in zip files and repairs corruption to recover your data. Software repairs and recovers all Zip files and zip archives. (more)
category: Management | clicked: 0 | comment | | source: www.repair-zip-file.com
tags: Zip Repair
1
kudos
spam Kudos Remove

Word repair
published 261 days, 1 hour, 58 minutes ago posted by macsmith85macsmith85 270 days, 14 hours, 37 minutes ago
Thursday, November 12, 2009 6:06:57 PM GMT Tuesday, November 03, 2009 5:28:37 AM GMT
Word repair
Word repairs, recovers corrupted or damaged Ms Word document / .doc Files to restore the word items like table, charts, images, bullets etc which have been corrupted or damaged. Stellar Phoenix Word Recovery Software will repair and recover lost data from corrupted Word files in almost all instances of Word corruption. (more)
category: Management | clicked: 0 | comment | | source: www.repair-word-file.com
tags: Word repair
1
kudos
spam Kudos Remove

Partitioning Tricks
published 285 days, 4 hours, 43 minutes ago posted by sasa 294 days, 22 hours, 8 minutes ago
Monday, October 19, 2009 3:22:40 PM GMT Friday, October 09, 2009 9:57:41 PM GMT
Partitioning Tricks
For those of you who are using partitioning, or who are considering using partitioning, allow me to share some tips with you. Easy Partition Staging Tables Switching partitions (or more specifically, hobts) in and out of a partitioned table requires the use of a staging table. The staging table has very specific requirements: it must be completely identical to the partitione... (more)
category: Management | clicked: 2 | comment | | source: sqlfool.com
tags: 2008, compression, partitioning, Performance, Performance & Tuning
1
kudos
spam Kudos Remove

Pause the passive node to apply SQL2005 Service Pack or hotfix
published 285 days, 4 hours, 43 minutes ago posted by sasa 294 days, 23 hours, 49 minutes ago
Monday, October 19, 2009 3:22:40 PM GMT Friday, October 09, 2009 8:16:42 PM GMT
Pause the passive node to apply SQL2005 Service Pack or hotfix
With SQL Server 2005, Microsoft tried to be helpful in enabling its installer to apply the service pack or hotfix automatically on the passive node(s) in a cluster. In my own experience, this has not worked out too well. Very often, when the installer flagged the upgrade status of the service pack ot the hotfix as failure next to Database Service, the information I found in the log file was that attempt to patch the passive node had failed. You could scour the log files, google the internet, and/or open... (more)
category: Management | clicked: 1 | comment | | source: sqlblog.com
tags: Cluster, Installation, SQL Server 2005
1
kudos
spam Kudos Remove

Rebuilding Indexes vs. Updating Statistics
published 285 days, 4 hours, 43 minutes ago posted by sasa 295 days, 2 minutes ago
Monday, October 19, 2009 3:22:40 PM GMT Friday, October 09, 2009 8:03:20 PM GMT
Rebuilding Indexes vs. Updating Statistics
One of the questions I was asked recently while speaking at user groups, was regarding the order that jobs like rebuilding indexes or updating statistics should be performed as part of the database maintenance activities. Then I started writing this post about this topic on the weekend but was interrupted several times, including one of them to watch the premiere on VH1 of the movie Anvil: The Story of Anvil.   In general, the order should not matter, at least if you carefully consider these importan... (more)
category: Management | clicked: 2 | comment | | source: sqlblog.com
tags: Indexes, statistics
1
kudos
spam Kudos Remove

Another use for the Default Trace: Mapping Temporary Tables to Sessions
published 296 days, 5 hours, 23 minutes ago posted by sasa 305 days, 6 hours, 33 minutes ago
Thursday, October 08, 2009 2:42:39 PM GMT Tuesday, September 29, 2009 1:32:49 PM GMT
Another use for the Default Trace: Mapping Temporary Tables to Sessions
Here’s another use for the information captured by the default trace.  Ever wonder what session created the tables that exist in tempdb?  Well you can find it using the default trace and the sys.objects view in tempdb.  Any time an object is created in a database, EventClass 46 (Object:Created) is captured in the trace output of the DMV.  By scanning the trace files for a matching ObjectID that was created 100 ms before or after the objects create_date with DatabaseID = 2 (tempdb) you can match the objec... (more)
category: Management | clicked: 1 | comment | | source: sqlblog.com
tags: Database Administration, Miscellaneous, Transact-SQL
Previous 1 2 3 4 5 6 Next