sqlphilosopher.com
SQL Agent Job Frequency Intervals in Plain English | SQL Philosopher
http://www.sqlphilosopher.com/wp/2013/01/sql-agent-job-frequency-intervals-in-plain-english
Brad Hoff's Notes about SQL. SQL Agent Job Frequency Intervals in Plain English. On January 27, 2013. So, now that we have examined what this integer really means, the question naturally follows: “How do we represent this integer as a series of days? Amp; [. WeekString, (. Strip off the last comma. And, the second T-SQL:. Job id ]. Freq interval ]. Job id ]. Job id ]. Schedule id ]. Schedule id ]. Freq interval ]. Amp; [. Job id ]. Job id ]. Job id ]. Job id ]. Job id ]. Leave a Comment Cancel reply.
sqlphilosopher.com
SQL CLR: An Introduction | SQL Philosopher
http://www.sqlphilosopher.com/wp/2013/03/sql-clr-an-introduction
Brad Hoff's Notes about SQL. SQL CLR: An Introduction. On March 3, 2013. The Origination and Uses of SQL CLR. Infrastructure Requirements and Configuration. Writing a Simple CLR Stored Procedure. Table-Valued Functions and Other SQL CLR (Coming Soon). Incorporating Existing Libraries (Coming Soon). I will update this post with links to the other blog posts as I write them. I hope that this short series will prove useful to those trying to wade through this technology. Click to print (Opens in new window).
sqlphilosopher.com
SQLPhilosopher | SQL Philosopher
http://www.sqlphilosopher.com/wp/author/sqlphilosopher
Brad Hoff's Notes about SQL. Resolving Disconnected SQL Server Mirrors. On February 1, 2016. On more than one occasion I’ve had a SQL Server mirror disconnect and reconnect repeatedly over a short amount of time, due to an unstable connection between the Principal and Mirror databases. Usually, this resolves quite quickly and the Mirror will begin re-synchronizing on its own. First, find the name of the endpoint, if you do not already know it, but issuing this command from the Principal side:. Normally, ...
sqlphilosopher.com
Writing a Simple CLR Stored Procedure | SQL Philosopher
http://www.sqlphilosopher.com/wp/2013/03/writing-a-simple-clr-stored-procedure
Brad Hoff's Notes about SQL. Writing a Simple CLR Stored Procedure. On March 3, 2013. Now that we have a basic understanding of SQL CLR. And have an environment configured to support the code we want to write. We can move on to writing our first SQL CLR stored procedure. I am going to start out with a very simple piece of code, but one that solves a common problem in SQL Server: Matching Regular Expressions. As I noted in a previous blog post. Put your code here. To Solve Our Problem. Now that we have a ...
sqlphilosopher.com
High-Availability | SQL Philosopher
http://www.sqlphilosopher.com/wp/category/high-availability
Brad Hoff's Notes about SQL. Resolving Disconnected SQL Server Mirrors. On February 1, 2016. On more than one occasion I’ve had a SQL Server mirror disconnect and reconnect repeatedly over a short amount of time, due to an unstable connection between the Principal and Mirror databases. Usually, this resolves quite quickly and the Mirror will begin re-synchronizing on its own. First, find the name of the endpoint, if you do not already know it, but issuing this command from the Principal side:. Normally, ...
sqlphilosopher.com
Poor Execution Plan While Ripping Large XML in SQL Server 2008 | SQL Philosopher
http://www.sqlphilosopher.com/wp/2013/01/poor-execution-plan-while-ripping-large-xml-in-sql-server-2008
Brad Hoff's Notes about SQL. Poor Execution Plan While Ripping Large XML in SQL Server 2008. On January 27, 2013. A few days ago, I ran into a very frustrating problem while trying to rip a large XML document into a table-structure in T-SQL on 2008. I am setting up a new procedure to process large files ( Download Sample File. C: Temp EnergyPrices92KLines.xml'. GLE BLOB ). Now, I know I could have just went into SSIS, or had the developers rip the XML in C# before passing it on to me, but this SHOULD wor...
sqlphilosopher.com
SQL Philosopher | Brad Hoff's Notes about SQL | Page 2
http://www.sqlphilosopher.com/wp/page/2
Brad Hoff's Notes about SQL. Poor Execution Plan While Ripping Large XML in SQL Server 2008. On January 27, 2013. A few days ago, I ran into a very frustrating problem while trying to rip a large XML document into a table-structure in T-SQL on 2008. I am setting up a new procedure to process large files ( Download Sample File. C: Temp EnergyPrices92KLines.xml'. GLE BLOB ). Now, I know I could have just went into SSIS, or had the developers rip the XML in C# before passing it on to me, but this SHOULD wor...
sqlphilosopher.com
Perform DBCC CheckDB Weekly using Red-Gate SQL Virtual Restore | SQL Philosopher
http://www.sqlphilosopher.com/wp/2012/02/perform-dbcc-checkdb-weekly-using-red-gate-sql-virtual-restore
Brad Hoff's Notes about SQL. Perform DBCC CheckDB Weekly using Red-Gate SQL Virtual Restore. On February 1, 2012. However, this poses other problems. Some of my databases are quite large, and doing a full restore takes a considerable amount of time and disk space. This is where Red-Gate. Red-Gate recently added a tool to their arsenal called SQL Virtual Restore. This tool allows the DBA to use Red-Gate’s HyperBac Filter Driver. With this tool at hand, I next needed to get my scripts written. Once the DBC...
sqlphilosopher.com
About SQLPhilosopher | SQL Philosopher
http://www.sqlphilosopher.com/wp/sample-page
Brad Hoff's Notes about SQL. Hello, my name is Brad Hoff. I have been working with SQL Server and Oracle for several years now. Throughout my experience with technology, I have found two things keep coming back to me: first, the more I learn, the more I find there is left to know, and second, sooner or later, everyone needs to seek advice/help from those who have faced the same sort of problems before. The unindexed table is not worth querying. Click to email this to a friend (Opens in new window). Resol...
sqlphilosopher.com
Database Maintenance | SQL Philosopher
http://www.sqlphilosopher.com/wp/category/database-maintenance
Brad Hoff's Notes about SQL. Category Archives: Database Maintenance. My Red-Gate Hyperbac DBCC CheckDB Script. On January 28, 2013. Several people have asked me to post my script for automatically cycling through each database in an instance, restoring a virtual hyperbac database, performing consistency checks, and then e-mailing out the results, in reference to my previous post. Thank you for your patience:. BACKUP DAYS THRESHOLD INT. NEW BACKUP FILE LOCATION VARCHAR. C: Temp BackupFileCopies '. Curren...
