SQL News, Information, Blogs and Feeds from Codango.org

SQLblog.com - The SQL Server blog spot on the web

• Updated slide decks from SSMS presentation at SNESSUG
• Yes, you can benefit from both data and backup compression
• Oracle Linked Servers on Windows Server 2008 R2
• World Class Training For Them, an Amazon Gift Certificate For You
• New T-SQL Functionality in SQL Server 2008

• What to leave when you're leaving
• Joel Spolsky Retires From Blogging in 3 Days
• New Extended Events Blog on MSDN
• Do you have Standard Operating Procedures in place for SQL?
• OT: NCAA Pick'em Returns...
• Document, Document, Document
• Collaboration Nation Call to Action! Calling All SQL Server Bloggers and Twitterers
• Quote of the Day – On the Importance of Truth
• On PASS Summit Locations, Time Will Tell
• Survey: which newsletters do you subscribe to? read?
• Survey: Do you find surveys annoying?
• Survey: How do you manage the source code for your personal projects?
• There once was in Dublin a query
• System Variables, Stored Procedures or Functions for Meta Data
• Dear ISV: You’re Keeping Me Awake Nights with Your VARCHAR() Dates
• Speaking at Triangle SQL Server User Group 16 Mar 2010!
• The ethics of aggregating other peoples' content
• Survey: How much data do you work with?
• Good News for Women in Technology - Barbie Has Joined the IT Scene
• Create Outlook Appointments from PowerShell

More »

SQL Server Magazine

• SQL Server 2005 SP4: What You Need to Know
• Could Piracy Limit Sources of SQL Server Help?
• Microsoft's Mark Souza Lists His Favorite SQL Server 2008 R2 Features
• SharePoint 2010: Microsoft's Thomas Rizzo Talks Details

Tool Time

• Collaboration Nation Call to Action! Calling All SQL Server Bloggers and Twitterers
• The All New SQLMag Blog Pages - With Over 5 Years of History

SQL Server Magazine News

• SQL Server 2008 R2 RTM Date Still Not Certain
• PowerPivot for Excel Download Now Available
• Quest Software Introduces Foglight for SQL Server at PASS
• Recruiters and Hiring Managers on "Getting the Job"
• SQL Server 2008 R2 November CTP Now Available

• PASS 2009: Tom Casey Dives into the New SQL Server 2008 R2 Editions and SQL Azure
• SQL PASS Summit 2009: New SQL Server 2008 R2 Editions Announced
• What's Coming at SQL Server PASS Summit
• Microsoft's Tom Casey Previews SQL Server PASS Summit 2009
• Project Gemini to Ship as SQL Server PowerPivot for Excel

More »

SQL User Group Insights

• Welcome to the Sqlmag.com Blog for User Groups!

Latest SQL-Server-Performance.com Articles

• A High Level Comparison Between Oracle and SQL Server - Part IV
• A High Level Comparison Between Oracle and SQL Server - Part III
• A High Level Comparison Between Oracle and SQL Server - Part II
• A High Level Comparison Between Oracle and SQL Server
• SQL Server 2008 R2 Multi-server Administration - A First Look

• An overview of Master Data Services - MDS in SQL Server 2008 R2
• Upgrade SSIS 2005 Packages to SSIS 2008
• Copy Only Backups for Adhoc Backups
• ASP.NET 4.0 - New Features
• Using The Data Mining Query Task in SSIS

More »

SQL Server Performance

• Have SQL email you if your Litespeed (or native) backups fail
• SQL Server Training Videos
• Life Changing Technology
• Google Scanning Project
• SQL Server 2008 SP1

• What a Mess
• Why Upgrade?
• Cell Phone Dependency
• Continual Learning
• People Watching
• Re-configuring RAID on the server - a detailed approach and best practices
• Looking Busy
• Cooking a Database
• Good to Be a Friday
• Keeping Up With the Competition
• What You Do
• Laziness
• SQL Standards
• Customer Service
• Best Practices
• What Version Is It?
• Paying It Forward
• Does Certification Matter?
• What Is a DBA?
• PerformancePoint No More

More »

SQL Server Performance: Active Threads

• SQL server Event Notification for lock timeouts
• Restore database through T-sql
• move data from a partitioned table to a different file group
• how do dba force developers to use schema name before table name
• Mirroring in XP machine?

• When installing Integration Services do you need to have IIS installed on the server?
• SQL server RAM usage
• SQL Express database stops responding
• Monitoring hardware configuration
• Recreate ##MS_PolicyTsqlExecutionLogin## & ##MS_PolicyEventProcessingLogin##
• Issues connecting through Management Studio
• Trouble installing SQL Server 2008 Enterprise Edition on Windows Server 2008 Ent R2
• How To Get a SQL Script with SPID
• Domain groups in Cluster Security policy during install of SQL Server 2008
• How To Locate a String That will be Occur in The Current Database?
• Create a Email Server
• SQL server 2005 and SQL server 2008
• replication
• Maint Plan Caused TLOG to Fill
• Table name in dynamic sql query
• SQL SERVER 2000 PRINT function not working
• tranfer data from one table to another that are not joined
• sql 2005 installation fails
• Move a table to other filegroup
• Urgent question - restore db from only .mdf file

More »

The SQLTeam.com Weblogs

• ClearTrace Supports Statement Level Events
• Blog...Dead & New Address
• SQL MDS - Updating the Name attribute of member using Staging Table
• SQLSaturday 33 Observations
• Fixed Bid vs. T&M – Take 2

• Troubleshooting Application Timeouts in SQL Server
• My first encounter with SmartAssembly
• Making Money from your SQL Server Blog
• Lessons from a SAN Failure
• MacGyver Moments
• WiX 3 Tutorial: Generating file/directory fragments with Heat.exe
• Clustering for Mere Mortals (Pt2)
• Fixing Robocopy for SQL Server Jobs
• WiX 3 Tutorial: Understanding main WXS and WXI file
• Guessing Excel Data Types

More »

SearchSQLServer: Expert advice on database administration

• Creating matrix reports with Report Builder 3.0
• Matrix configuration techniques for Report Builder 3.0
• Enter the matrix with Report Builder 3.0
• Native string manipulation functions for SQL Server
• Backing up SharePoint-related SQL Server databases

• Getting set up for multi-server management with SQL Server 2008 R2
• SQL injection tools for automated testing
• Log shipping: Four tips to maintain RTO and RPO with SQL Server
• Geospatial mapping made simple with Microsoft SQL Server
• Finalizing maps with Report Builder 3.0

More »

SearchSQLServer: Expert advice on database development

• Enter the matrix with Report Builder 3.0
• Creating matrix reports with Report Builder 3.0
• Matrix configuration techniques for Report Builder 3.0
• Native string manipulation functions for SQL Server
• Adding a polygon layer to a map in Report Builder 3.0

• Finalizing maps with Report Builder 3.0
• Geospatial mapping made simple with Microsoft SQL Server
• Ten key changes with SQL Server 2008 R2
• Report Builder tutorials and resources for SQL Server
• CTP released for MySQL migration toolkit

More »

SQL Server Community Blogs

• VBUG Manchester March 3rd 2010 - Slides and examples
• SSMS - Please get keyboard shortcuts working for schemas
• Relational Database pioneer Chris Date is giving a seminar 13th/14th May Edinburgh on "SQL and Relational Theory - How to Write Accurate SQL Code"
• Database Design - Surrogate keys: Part 1 of many (Rules for Surrogate Keys, E. F. Codd and C J Date research and problems they solve)
• Visual Studio Professional 2010 upgrades

• ORMs - Should DBAs just lighten up?
• Learning SQL Server
• Coding standards
• SSIS - XML Source Script
• SQL 2008 R2 UK Launch
• PASS Summit Location follow up - result analysis
• We've increased the number of sessions for SQLBits VI
• We've increased the number of sessions for SQLBits VI
• PASS Location fixed for the next 2 years - Are they listening?
• Did you know you can shrink a transaction log even when log shipping?
• New e learning course on Business Intelligence
• When a query plan goes wrong - Video updated
• Finding rows that intersect with a date period
• SQL Deprecation event uses depracted feature
• SQLBits VI session submission - Today is your last day
• SQLBits VI session submission - Today is your last day
• How to archive data from a table to a local or remote database in SQL 2005 and SQL 2008
• "Give with Bing" - Help raise money for Sports relief while searching for whatever you want
• What is Granularity?
• Something for the weekend - Whats the most complex query?

More »

active questions tagged sql - Stack Overflow

• Whats a difference between drop and delete database??
• SQL to LINQ Converter
• UNIQUE and PRIMARY KEY
• What is wrong with this SQL query? (or perhaps why doesn't MySQL like the sixth field?)
• SQL Server Reporting Services Change report layout to Portrait

• SQL - Select all when filter value is empty
• Problem with SQL connection on virtualised machines
• What is so bad about using SQL INNER JOIN
• Asynchronous callback - gwt
• Very difficult SQL query
• Get mutually and non mutually existening Fields in same table in Two columns
• Minimizing SQL queries using join with one-to-many relationship
• aspx connet to sql 2008 in another ip by win authorization
• Dealing with large number of text strings
• How do I Put Several Select Statements into Different Columns
• help with tree-like structure
• Performance improvement to a big if clause in SQL Server function
• MySQL function to compare values in a db table against the previous
• Selecting multiple fields into multiple variables in a MySQL stored procedure
• How to add condition on multiple-join table
• Run MySQL INSERT Query multiple times (insert values into multiple tables)
• Would this method work to scale out SQL queries?
• SQL Server trigger that rounds values
• SQLite long to wide formats?
• Why use INCLUDE in a SQL index
• Parameterizing a SQL IN clause on an integer column?
• Unable to get my master & details gridview to work.
• ordered SQL Select columnwise distinct but return of all columns
• Wanted: Good examples of Scala database persistence
• Using a Oracle subselect to replace a CASE statement

More »

w3schools.com - SQL Forum

• update adds new row
• update database automatically
• Memo Field
• Cast
• I Need A Query Method

• Delete Join Where Second Table Could Be Empty
• Mysql And Pgsql?
• Change Time That Db Adds Automaticly
• Adding Up Lines
• Password Function
• Table Information
• Ordering A Select Statement By Primary And Secondary Columns
• Connecting To Non Localhost?
• Create Table With Now() Column
• Whats Wrong With This Sql ?
• League Table
• Getting Yymd
• Date Problem?
• Date Extract
• Two Tables One Query
• Batch Job On Linux
• Solved
• Mysql Dump
• Mysql Error 1064 (resolved)
• Update Help?
• Need Help Setting Up A Query To Display A 24-hr Time Frame
• Mysql Update Set Problem?
• How Best To Store And Search A Lot Of Data
• Mysql Date Help?
• Search Function
• Sql Queries Question - Multiple Tables
• Union
• Is It At All Possible To Set A Default Timestamp Value To A Function?
• Foreign Keys
• Convert Php If Statements To Mysql
• Help In Mysql?
• Get Autoincrement Id By Insert Command
• Import Data From Excel File
• Formatted Entries
• What Database The Better?
• Display Summary Report Using A Simple Query In Mysql
• what are data bases made to store?
• Mysqli Extends
• Mysqli Is Better
• Implementing Sameserver, Cross Database Field Copying (multiple Fields)
• Mysql Select Join Across 3 Tables Error #1241
• Add Value Of Two Columns?
• Mysql Help?
• { } Characters In Sql
• Search On Several Columns
• Pre-define Rows To Commit Too
• Splitting Data From One Field Into Others
• Can I Use Php Variables In Mysql Code? (solved)
• Mysql Daily Action
• Sending E-mail On Sql Server 2005 Express Edition
• Sqlncli Provider Not Registered On Local Machine
• Sql Rows, Columns, Cells, Records
• Storing Values In Php Variables
• What Am I Doing Wrong? Please Help!
• Insert Not Working
• Collation To Use With German
• How To Set Up A Sql Report That Uses A Unique Date Code System
• Sql Date Select
• Phpmyadmin
• Select Last Time - Minute By Minute Data
• Help With Mysql Error
• Simple Sql Query Not Working
• One More Sql Error..
• Passing The Data Into <a> Tag
• Add Same Amount To Various Product Prices
• Which Is The Fastest Ole Db Provider ?
• Multiple Forms Data Submit Into Mysql With One Button
• How To Query 3 Tables Help!
• Database Search Optimization
• Sql Colum Type
• Selecting Rows With A Unique Value
• Need Help Setting Up Sql Query To Display A Specific Date
• Limit/sort Text Query Help
• Reusing Auto-increment Id's
• Help! Why Does This Mysql Query Return Boolean In Php?
• Query Of Percentage Table In A Database Of Students
• Field Null = No With No Value
• Db Selection
• Mysql-storing File Locations
• 2 Forums 1 Database
• Can The Timestamp Format Be Change
• Advanced Sum
• Problem Using Backtick With Reserverd Word
• Navigating Mysql In The Command Line Utility
• Bcp Csv
• Database And Table Collation
• Multi-table Join
• Double Count() With Many Join Returns Wrong Values
• Want To Combine Data From Two Tables
• Mysql Stored Procedure Error
• Question For Load Statement
• Add Column To Existing Table
• Error When Executing Query -> Ora 00913: Too Many Values
• Strange Characters In Mysql
• Updating Certain Records Within A Table With New Values

More »