Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tag
Blogs
Refine your search with one of the following additional tags (with number of items):
Career
(28)
Replication
(2)
Error Handling
(1)
productivity
(1)
SQL Server
(17)
social networking
(2)
ETL
(1)
Query performance
(1)
networking
(16)
String Manipulation
(2)
Exchange
(1)
Recursion
(1)
Security
(15)
time management
(2)
Execution Plans
(1)
Report Builder
(1)
pass
(9)
Tools
(2)
FILESTREAM
(1)
Reporting Services 2008
(1)
SQLSaturday
(8)
Training
(2)
For Each Task
(1)
review
(1)
PASS Summit
(6)
trust
(2)
Fundamentals
(1)
Salaries
(1)
SQL Server 2005
(6)
T-SQLScripts
(2)
Graphs
(1)
Schema
(1)
T-SQL
(6)
Twitter
(2)
grouping sets
(1)
SCRUM
(1)
Book Reviews
(5)
Windows 7
(2)
Hard Disk
(1)
server principals
(1)
Hardware
(5)
Adobe Flash
(1)
hashing
(1)
Shrinking Databases
(1)
Interviews
(5)
agile
(1)
HP Data Protector
(1)
Sparse Columns
(1)
Patrick LeBlanc
(5)
Analysis Services
(1)
I/O
(1)
SQL Agent
(1)
SQL Server 2008
(5)
Analysis Services (SSAS)
(1)
I/O Statistics
(1)
SQL Connections
(1)
SQLServerCentral
(5)
Articles
(1)
Indexing
(1)
sql injection
(1)
Database Mirroring
(4)
Auditing
(1)
integrity
(1)
SQL Server 2000
(1)
powershell
(4)
Backup and Recovery
(1)
Job Trends
(1)
SQL Server Architecture
(1)
Reporting Services (SSRS)
(4)
Business Intelligence
(1)
Jobs
(1)
SQL Server security
(1)
Administration
(3)
Certifications
(1)
leadership
(1)
SQL University
(1)
Databases
(3)
charity
(1)
Live Meeting
(1)
SSD Disks
(1)
humor
(3)
checkpoints
(1)
Log Shipping
(1)
SSPI
(1)
learning
(3)
Code
(1)
Maintenance Plans
(1)
Star Join
(1)
LinkedIn
(3)
Compression
(1)
Management
(1)
Storage
(1)
Professional Development
(3)
cross apply
(1)
MCTS
(1)
Stored Procedures
(1)
speaking
(3)
Crystal Clear
(1)
Memory
(1)
Surface Area Configuration tool
(1)
SSIS
(3)
data
(1)
Microsoft SQL Server
(1)
Table Valued Function
(1)
Backup
(2)
Data Modeling
(1)
Migration
(1)
Test Data
(1)
Disaster Recovery
(2)
Data Warehousing
(1)
Misc
(1)
transactions
(1)
Encryption
(2)
Database Design
(1)
MSDE
(1)
Try-Catch
(1)
Events
(2)
Database Development
(1)
MVP
(1)
User Defined Function (UDF)
(1)
Integration Services (SSIS)
(2)
database principals
(1)
netbook
(1)
User Group
(1)
Microsoft
(2)
database security
(1)
netbooks
(1)
Virtualization
(1)
off-topic
(2)
Date Manipulation
(1)
Passwords
(1)
Voice of the DBA
(1)
Performance
(2)
DBA
(1)
PBM
(1)
Windows
(1)
Performance Tuning
(2)
Deployment Process
(1)
Presenting
(1)
writing
(1)
Permissions
(2)
dimension
(1)
procedure cache
(1)
XML
(1)
Red Gate Software
(2)
Items 1 to 20 of 212
Next 20 >>
SQL Server 2008 Diagnostic Information Queries
Here is the script that I used in my Dr. DMV presentation this afternoon at PASS. It is a set...
Read more...
By
glennb
2009/11/05
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
Rate this
|
Briefcase
|
785 reads
Suggested Max Memory Settings for SQL Server 2005/2008
It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something...
Read more...
By
glennb
2009/11/04
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,936 reads
SQL University: Multiple Paths and Ownership Chaining
Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...
Read more...
By 2009/11/03
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
480 reads
Electronic Health Records – What’s the Big Deal? (Part 2)
In the first installment of this discussion, I talked about the challenges facing database professionals and others with respect to...
Read more...
By
Tim Mitchell
2009/11/02
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,046 reads
Where Will We PASS Each Other?
In my a post on Monday, I talked about who I want to meet while at the PASS Summit. Today...
Read more...
By
Jack Corbett
2009/10/30
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
208 reads
My Schedule at the Summit/Let’s Connect
I’m flying out Sunday via Alaska Air, taking the direct flight from Orlando to Seattle, arriving at 11:40 am. If...
Read more...
By
Andy Warren
2009/10/30
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
148 reads
SSRS - Setting Default Parameter Values for Analysis Services Datasets
When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult...
Read more...
By 2009/10/28
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
495 reads
PASS Update #18
Eric Wisdahl posted some questions on my last update, and I thought I’d reply here to make my answers more...
Read more...
By
Andy Warren
2009/10/27
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
264 reads
What Direction Do You Choose?
You have brains in your head. You have feet in your shoes. You can steer yourself, any direction you choose. Dr. Seuss
Read more...
By 2009/10/27
|
Source:
SQLServerCentral.com
|
Category:
pass
Rating:
(not yet rated)
Rate this
|
Briefcase
|
657 reads
Characters
No, I’m not talking about a Dickens novel. I’m talking about the number of characters in a string. I had a painful time recently because of the word “characters.”
Read more...
By
Steve Jones
2009/10/26
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
Rate this
|
Briefcase
|
837 reads
Review: ASUS Eee PC 1005HA Netbook
Our home desktop was several years old and due for replacement. I still have my Dell laptop, and it's still more than...
Read more...
By 2009/10/23
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
853 reads
SharePoint 2010 And SQL Server 2008 R2
Lots of interesting news and announcements coming out of the SharePoint 2009 Conference that started today in Las Vegas. Microsoft’s...
Read more...
By
glennb
2009/10/23
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,121 reads
Transparency and PASS
I hate to start a blog war, but maybe there's one going on. The recent PASS 2009 election concluded a...
Read more...
By
Steve Jones
2009/10/22
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
Rate this
|
Briefcase
|
384 reads
Electronic Health Records – What’s the Big Deal? (Part 1)
Last week, I had lunch with an old friend who is, by his own definition, technologically ignorant. While we caught up, he asked me to explain in terms he could understand what I do for a living. I went through one of my spiels (the one usually..
Read more...
By
Tim Mitchell
2009/10/21
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,541 reads
SQL Server Legend – Data Files and Threads
Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...
Read more...
By
Steve Jones
2009/10/20
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
779 reads
Generate Lots of Test Data with CROSS JOIN
“Joe Test” “Joe Test2? “Joe Test3? “Arrgh! There has got to be a better way to create some test data!” Ever had that conversation...
Read more...
By
Joe Webb
2009/10/19
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
Rate this
|
Briefcase
|
1,002 reads
Work on a Strength or Weakness?
When deciding what to learn, there's a binary decision. Will you focus on a strength or a weakness? I think many people focus mostly on their strengths because they have a goal of really standing out in something. They perhaps want to avoid being..
Read more...
By
Bill Nicolich
2009/10/16
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
637 reads
Sparse Columns – ConvertSVtoXML & XMLToResv
Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. I’d venture that those serve to convert back/forth from XML storage.
Read more...
By
Andy Warren
2009/10/15
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
376 reads
Maintaining Security and Performance using Stored Procedures Part I – Using EXECUTE AS
Anyone who knows me, or has worked with me, knows that I am a proponent of using stored procedures for...
Read more...
By
Jack Corbett
2009/10/14
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,458 reads
MSDE – Database Size Limit
Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...
Read more...
By
Patrick LeBlanc
2009/10/13
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,171 reads
Items 1 to 20 of 212
Next 20 >>
Most popular
I/O I/O - It's why my server's slow.....Examing I\O Statistics
I/O I/O - It's why my server's slow..... Often I've been curious about ways to measure the performance of SQL Server, and...
Read more...
By
Robert Pearl
2009/08/20
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
Rate this
|
Briefcase
|
2,559 reads
Evil Code
/* A couple of years ago, when I wrote the Simple-Talk Prettifier that is really no more than a stored procedure...
Read more...
By
Phil Factor
2009/08/18
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
Rate this
|
Briefcase
|
2,127 reads
The secret skill revealed in the dusty booklet
Going through one’s father’s belongings after his death is always a poignant, bitter-sweet experience. I was going through his most precious books a while back; there were books that were written by him, books by friends and relatives, books about friends...
Read more...
By
Phil Factor
2009/06/26
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
Rate this
|
Briefcase
|
2,148 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use