Geeks With Blogs

@mikedopp
  • mikedopp space heater at full blast and still just enough to keep the keyboard defrosted. Ah spring to summer transition. about 486 days ago
  • mikedopp favorite google search of the day [filetype:xls confidential] find out salaries of your favorite people. about 492 days ago
  • mikedopp enjoying the multi-window update fer my S3 :) about 492 days ago

News

mikedopp Geekswithblogs (edition) MSSQL There are 3 entries for the tag MSSQL
All Your Base Belong to SQL or Backup all your SQL Databases with one Query
Most of you would rather the the first title before or. Can't Remember where I got most of this script(if you know please send me a hate email) however I did some enhancements and I am reposting it. DECLARE @DBName varchar(255) DECLARE @DATABASES_Fetch int DECLARE DATABASES_CURSOR CURSOR FOR select DATABASE_NAME = db_name(s_mf.database_id) from sys.master_files s_mf where -- ONLINE s_mf.state = 0 -- Only look at databases to which we have access and has_dbaccess(db_name(s_mf.d... = 1 -- ......

Posted On Thursday, April 24, 2008 7:25 AM

MIX08-Using the Microsoft Sync Framework and FeedSync
Download Video FeedSync (Project) Astoria Offline (Project) Take Data offline? Alter Remote Offline Data and use FeedSync to update when connected. Reasons: App availability Network Utilization Lower costs Leverage client UI Leverage Service Extend for collaboration Flexible: Write a provider for Service Desktop Devices Protocols extensions Metadata Handles arbitrary topology peer to peer mesh and point to point Layers: End to End Solutions Ado.NET Sync Astoria Offline Protocol and Store Providers ......

Posted On Friday, March 7, 2008 5:55 PM

MSSQL 2000 Tip of the day
So I get this email. I forgot/lost the sa password. What to do? So I scrub the google database. Looking for an answer: Source Forgot or lost your sa password? Don't worry, there is a way out. Login to the SQL Server computer as the Administrator of that computer. Open Query Analyzer and connect to SQL Server using Windows NT authentication. Run sp_password as show below to reset the sa password: sp_password @new = 'will_never_forget_again', @loginame = 'sa' Technorati Tags: SQL 2000, MSSQL, Microsoft, ......

Posted On Monday, January 21, 2008 8:13 AM

Copyright © mikedopp | Powered by: GeeksWithBlogs.net | Join free