|
Today we noticed our transaction log backups had started failing for our user databases. From previous experience, I had a hunch that someone had created a new database that was in SIMPLE recovery model. Just an FYI... That will cause the log backup to fail. Hum... This server has hundreds of databases... Now which is the culprit. Here is a query you can use to find the recovery model of all you databases. SELECT
'DbName' = name
, 'RecoveryModel' = DATABASEPROPERTYEX(name, 'Recovery')
FROM master.dbo.sysdatabases
ORDER BY name
Now... To find which one is SIMPLE?
SELECT
'DbName' = name
, 'RecoveryModel' = DATABASEPROPERTYEX(name, 'Recovery')
FROM master.dbo.sysdatabases
WHERE DATABASEPROPERTYEX(name, 'Recovery') = 'SIMPLE'
ORDER BY name
Sure enough... There was a database in SIMPLE recovery model.
Hope that helps someone...
I have been reading this blog for some time (one of the best on SQL Server). Ya need to check out yesterday's post (a list of Microsoft Whitepapers on SQL 2008). If you want to learn more about Microsoft SQL Server and SQL coding... I HIGHLY encourage you to check out the SQL Server Code,Tips and Tricks, Performance Tuning blog. I love the quote from the site... (being a big Yoda fan & SQL Server fan & Geek) I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime... Downtime leads to suffering... Fragmentation is the path to the darkside... DBCC INDEXDEFRAG and DBCC DBREINDEX are the force... May the force be with you" And how their email address is protected... genius... "run the code below in Query Analyzer/Management Studio to get my email"
SELECT CONVERT(VARCHAR(31),0x73716C736572766572636F646540676D61696C2E636F6D)
Some weird Internet searches that brought people to my site: FYI: No one got here searching for boobies like on my other blog! - toilet rss reader (kinda interesting)
- 80072745 (by far the most referred search!!!)
- Windows live Massager 80072745 (Massager???)
- enternet explorer (hehe)
- www.acstechnologies.not program (.not ???)
- stupid programmer (hum... how did that happen?)
- free metal music (sign me up!)
- Code Advisor (at StupidProgrammer.com?)
- christopher reeder (hey...that's me)
- sql prompt 3.5 (GREAT product)
- "chris craft" taylor data systems (that would be http://cjcraft.com/blog/)
- fayetteville nc "users group" c# (not one... try http://pdanug.net)
- using radio button if,then ,else statement in vb.net (that is a refined search!)
- "Chris Reeder Rocks" (just kidding... made that one up)
- "Free is for me" (ya got that right!)
It is neat to take a look at how people end up at your site... And these are just since January 1st, 2008!
Tuesday, February 12th, 2008
Bill Ryan
Topic: ADO.NET 3.5 (LINQ) and Windows Home Server! Tuesday, February 12th, 2008, is the next meeting of the Pee Dee Area .NET User Group. Bill is a typical .NET Nerd, and a Microsoft MVP. Currently, he works as a Principal Consultant and Technology Evangelist for Magenic Technologies in Atlanta, GA. He is quite active in the development community speaking frequently at users groups, code camps and web casts. In addition, Bill has authored several books and worked extensively with Microsoft and partners to develop training content for the MCTS and MCPD certification exams. In addition to spending most of his time playing with ADO.NET and the .NET Compact Framework, he helps run http://www.knowdotnet.com/ and http://www.devbuzz.com/. Part I: ADO.NET 3.5 (LINQ)
Bill Ryan will be doing an overview of ADO .NET 3.5, in particular LINQ, in preparation for an advanced ADO.NET course he'll be doing in Stockholm, Sweden. So be sure to bring your tough questions. Part II: Windows Home Server Bill Ryan will follow up with an overview on Windows Home Server cover everything from how to set it up, all the way to what all can it do. If possible, he will bring his Windows Home Server and let everyone see it for themselves. Please click the link below to register. We use this information to determine how much food to buy! 
Tentative schedule: 6:00 PM - 6:20 PM Socializing / Free Dinner
6:20 PM - 6:30 PM Introduction, Sponsor Time, and News.
6:30 PM - 7:15 PM Presentation
7:15 PM - 8:00 PM Drawing for free stuff / Wrap Up
 Last year, our local .NET User Group held a four session .NET University to cover the 3.0 Framework (WPF, WCF, WF, and CardSpace).
Now, thanks to Karl Rissland (special thanks to Doug for sharing the information), there are sessions for BizTalk. You can get all the information over at the .NET University Site (Power Points, videos, labs, etc...). If there is anyone that would like to present the material at our Pee Dee Area User Group, please let me know!!!
For those that have never heard of this product... You should check it out. Microsoft recently released a new version (FREE) downloadable here. What is it you ask... The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment. It provides a great deal of information about your servers. I ran it on my local SQL Server so I could show an example and it found this. Apply Cumulative Update to Improve Query Performance On versions of SQL Server before 9.0.3171.0, a known issue can degrade query performance on 32-bit and 64-bit systems with 2 gigabytes (GB) or more of memory. When you execute queries under the context of a login that is not a member of the sysadmin fixed server role, you might encounter performance degradation symptoms that arise from a large and growing Security Token cache. These issues can include performance degradation of queries, high CPU usage for the SQL Server process, and a sharp increase in worker threads and SQL user connections. Systems that have less than 2 GB of memory should not experience these issues because normal memory usage requirements keep the Security Token cache from growing too large. Best Practices Recommendations Apply the latest cumulative update package or cumulative update package #3 from the SQL Server Support page to SQL Server versions before 9.0.3171.0. Alternatively, you can apply the following hotfixes, which are all included in cumulative update package #3. - KB article 927396: Queries take a longer time to finish running when the size of the TokenAndPermUserStore cache grows in SQL Server 2005
- KB article 933564: FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005
- KB article 937745: FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections
Kinda interesting stuff. Other items listed (for more examples). Keep in mind, this is my local SQL development server... don't be too critical  - Sysdtslog90 Table is found in [msdb] database on Server [slowMachine]. Do not create the Sysdtslog90 table for logging in the [master] and [msdb] databases. This is not a security related concern but could be a performance issue since SSIS can generate a lot of logging data. We recommend creating a separate database for logging.
- Login [goodUserBlah] on Server [slowMachine] has Password Policy set to [True] and Password Expiration set to [False]. We recommend that both Password Policy and Expiration must be enabled for SQL accounts.
- Service [MSSQLSERVER] on host [slowMachine] is found to be running under LocalSystem account. We recommend that SQL Server services should not run under LocalSystem account.
- Database [awesomeDatabase] on server [slowMachine] does not have PAGE_VERIFY option set to 'CHECKSUM'. We recommend setting PAGE_VERIFY option to 'CHECKSUM'.
- It's found that DBCC CheckDB for database [awesomeDatabase] on server [slowMachine] has not executed ever since the database created. We recommend you to check the database for integrity at least once in 14 days.
Anyway... you get the idea... SQL 2000 Version here. NOTE: You will need registry access to scan the SQL Server.
 Wow! What a night last night. We (PDANUG) had the pleasure of having Brian Hitney and Chad Brooks come to little ole' Florence, SC. It was exciting to see 33 techies crammed into our conference room with laptops and power strips everywhere!
Watching everyone play guitar hero was fun... lets just say... some people are obviously better than others! And it showed! I am speaking for Florence and the rest of South Carolina, a location that does not get credit for being the tech center of the South.... Thank you both for everything you guys do for us!!! YOU BOTH ROCK!!!
Oh yeah... Getting a FREE copy of Visual Studio 2008 rocked too!!!
We have a saying where I grew up (Lancaster, SC): "Free is for me"
Coming to Florence, SC, tomorrow, December 11th, 2007!!! Pee Dee Area .NET User Groups Presents: Brian Hitney & Chad Brooks
Topic: Visual Studio 2008 Install-fest!!
Directions: http://pdanug.net Tentative schedule: 6:00 PM - 6:20 PM Socializing / Free Food / XBox 360 Play
6:20 PM - 6:30 PM Introduction, Sponsor Time, and News.
6:30 PM - 8:00 PM Presentation / VS 2008 Install-fest and Wrap Up I know I posted about this here, but I wanted to remind everyone planning on attending to please register. To do so, follow the link below: 
And if you are not currently subscribed to the Pee Dee Area .NET User Group blog, you can here  to keep informed.
Coming to Florence, SC; December 11th, 2007!!! Pee Dee Area .NET User Groups Presents: Brian Hitney
Topic: Silverlight and AJAX Development with Visual Studio 2008 + Visual Studio 2008 Install-fest!!
 We have a very special holiday event planned for December! Brian Hitney from Microsoft will be dropping in to give us an overview of Silverlight and AJAX development in Visual Studio 2008. You don’t want to miss this event because Brian will be bringing with him a FREE COPY of Microsoft Visual Studio 2008 Professional for each attendee! That’s right, a free copy to all attendees! However, there are some rules that you must follow: - You must be present to receive a copy of Visual Studio 2008 Professional.
- It is highly recommended that each attendee bring their laptop/desktop to the event, after all, this is an install-fest. For those people with desktops, we may have a few extra LCD panels at the event for general use but they will be first-come first-serve.
- Quantities of Visual Studio 2008 Professional are limited and the people who bring their computers will be first in line. In other words, if you don’t bring your computer and we run out of copies to hand out, you simply won’t receive a copy.
- These copies of Visual Studio 2008 Professional are Not for Resale. (No E-bay!!!)
Please register here so we have an idea of how many people will be attending.
Tentative schedule:
6:00 PM - 6:20 PM Socializing / Free Dinner
6:20 PM - 6:30 PM Introduction, Sponsor Time, and News.
6:30 PM - 7:15 PM Presentation
7:15 PM - 8:00 PM VS 2008 Install-fest and Wrap Up Hope to see you there!!!
 It is here... With everyone promoting the released of Visual Studio 2008...
What about SQL? Yeah I know, not yet RTM... but an update either way. Get it while it's hot! (download here) Also, Express Edition is now available with this release...
Ya gotta be kidding me!!! Only FOUR MORE EPISODES of Heroes before re-runs!!! This "writers' strike" stinks! According to TV Guide, the December 3rd episode has been reworked to possibly serve as the season finale... Visit here for a complete list of show's that are going in the dark soon. Man... this stinks... Did I already say that this stinks? FOUR more Heroes! What are we going to talk about on Tuesday Mornings... Someone... Please say it ain't so!!!
I have noticed that twice in the past week FeedBurner has not reported any Google Reader subscribers. I have confirmed this on my other blog, Susanne's blog (wife), and Chris Craft's blog. Yesterday... 47 Subscribers... 19 Subscribers on Google.  Today... 29 Subscribers... 0 Subscribers on Google. 
The same thing happened on November 3rd too. Anyone else have this going on? Any clue what is up?
 As many of you may already know, Susanne and I surrendered to God's call to ministry last March. We have been fervently praying for God's will in our lives, and for His guidance in the next step(s) we should be taking in obedience to accomplish His will.
After much prayer, we have decided to sell our home. We have had a burden on our hearts for over a year now concerning financial freedom (thanks Joe), and while we have made great strides in getting there, we feel that this will be a BIG STEP towards finally making it happen! We know that God is in control, and we have already found a home that is going to be a step of faith. We are trusting that God will sell our house quickly and He can make it happen! Buy purchasing this home, we will accomplish two things...we will be DEBT FREE except for a mortgage (which by the way will be a little more than half of what we are currently paying) and we will also be fulfilling a dream of being "out in the country" on a few acres of land.  Please pray for favor with the owners of this property (a sister and two brothers selling their mother's home) and for God's perfect plan to be accomplished. We have not listed our house with a realtor because financially that would be a bit of a set back, so we are trying to sell it on our own.
We have constructed a website at www.2121TwinBridge.com for potential buyers to view, and we have made printable flyers to distribute. If you know of anyone that would be interested in buying our house, please let them know. Otherwise, please pray that the house will sell quickly and that we will be able to accomplish our financial goals.
Thank you all so much for praying, and for being wonderful brothers and sisters in Christ who we can turn to in our trials, laugh with in our joys, weep with in our sorrows, and celebrate with in our successes. We cannot imagine doing this "thing" called life without you all!!!
 Had to pass this along to anyone that needs to purchase a Domain Name.
I just purchased a new domain name and the initial cost was $10.15 I entered Code OYH3 and it lowered the cost to $7.15. Great Savings!!! (Home for Sale @ www.2121TwinBridge.com) Other valid promo codes are: OYH1 & OYH2. (found the codes here)
|
|
|