New Horizons Get Schooled Blog

Use GETDATE() to pull a Monday-to-Sunday report no matter when it’s created (SQL Server)

Posted on 12/3/18 8:41 AM by Get Schooled in SQL Server, in SQL

In a perfect world, reports would be pulled on the same day and time every week to achieve maximum consistency. Unfortunately, mere mortals cannot maintain this regularity without fail. It only takes one unforeseen circumstance to throw the reports off.

Fortunately, the GETDATE() function replaces human fallibility and pulls a dynamic weekly performance data report starting on any specified day. This provides flexibility to the program and maintains consistency. A real win-win!

To specify the report start date use: WHERE CAST(table.Date as DATE) < CAST(DATEADD(DAYS, -DATEPART(dw, getdate())-1), getdate()) as DATE). If this code is run on a Tuesday, the results will begin on the most recent Monday and so on until Sunday.

0 CommentsContinue Reading →

Use ALT+F1 when highlighting a table for a quick list and column definition (SQL Server)

Posted on 11/5/18 8:00 AM by Get Schooled in SQL Server



Next time you need to look up a column definition or information on a database object, highlight the table object and press ALT+F1. This will trigger the SSMS IDE to run a command equal to sp_help ‘object_name’. The object name is the highlighted text. The only idiosyncrasy of this shortcut is that the highlighted object must be connected to its corresponding database. As long as that’s the case, this shortcut can save lots of time!

0 CommentsContinue Reading →

Split large SQL files for data that can be successfully uploaded (SQL Server)

Posted on 8/30/18 11:49 AM by Get Schooled in SQL Server, in PHP

Just like parents tell their children to take smaller bites when they eat so they don’t choke, by default, phpMyAdmin can’t swallow file sizes larger than 2mb. This can cause quite the headache when you need to import a long SQL file that ends up too big.

Rather than breaking up the SQL file manually and possibly loosing vital information, run a simple command line script to take care of the heavy lifting for you. Not only will it improve accuracy, but it will also be completed in less time.

0 CommentsContinue Reading →

Avoid headaches: Eliminate transitive dependency in your database design (SQL Server)

Posted on 7/13/17 9:47 AM by Get Schooled in SQL Server

Left unchecked, transitive dependency easily causes bugs and data loss. Basically, your logic for vital information and how it’s stored is incorrectly dependent on other information. This is okay as long as nothing is ever changed, but as soon as something is added, deleted, or moved, you may unintentionally trigger a domino effect on relying data.

0 CommentsContinue Reading →

Simplify SQL Server reporting with the OVER clause (SQL Server)

Posted on 6/12/17 8:58 AM by Get Schooled in SQL Server

Report requirements often contain requests for pieces of data that don't conform to the kind of output generated by basic SQL queries. For instance, a report may need to show an educational program's average score next to each student's average score. This kind of request could be handled in some report-writing program that processes the data after it comes out of the database. However, reporting is generally much easier if the query results correspond closely with the requirements for the report output.

0 CommentsContinue Reading →

Web-based app developers in high demand

Posted on 1/31/14 8:04 AM by Get Schooled in IT Career, in IT News, in SQL, in SQL Server, in training, in web design

The world is going increasingly mobile. According to ZDNet contributor Matt Baxter-Reynolds, the mobile Web is dead. Native apps have taken over as the preferred means of Web connection for countless Internet users, and companies that require these apps are taking notice. According to Robert Half Technology's 2014 IT Salary Guide, Web developers will be one of the most in-demand professions of the next new year, and they will need to be trained in development tools like SQL.

0 CommentsContinue Reading →

Don’t let SQL Server date-related queries miss important records

Posted on 7/9/13 8:39 AM by Get Schooled in date queries, in IT Career, in Microsoft, in SQL Server, in Tips & Tricks

You may think that querying the records between two dates is a simple process. But if you forget to consider both the date and time values, you may not get the results you want. And because such data omissions usually don’t cause software errors, they may never get fixed, and nobody will ever know what caused, say, someone’s medical records or banking transactions to go missing.

0 CommentsContinue Reading →

Diagramming your SQL databases

Posted on 1/8/13 11:51 AM by Get Schooled in Database Diagram, in Enterprise Manager, in Microsoft, in SQL Server, in Tips & Tricks

SQL Server 7.0 includes the ability to create a graphical diagram of your database. You can use this diagram to view the structure of all tables in the database, as well as links between the tables in the database. SQL Server displays the primary key-foreign key link between tables.

0 CommentsContinue Reading →

Career Focus Tip #5: Database Careers

Posted on 6/21/12 9:08 AM by Get Schooled in Access, in Brian Parker, in Career Development, in Database careers, in Guest Blogger, in Guest Bloggers, in IBM DB2, in IT Career, in Microsoft, in MySQL, in Oracle, in SQL Server, in Tips & Tricks

GUEST BLOGGER: Brian Parker, Technical Instructor

Database management is broken into three general sections: design, engineering (or development) and database administration (DBA). Sometimes the designers and engineers work together, or one person may fill both roles. Once the database is designed and developed, then the administrators make minor tweaks as needed and manage the data to ensure consistency and continuity. Database admins also work to clean, archive and compress the database to ensure optimal operation. In smaller businesses, these jobs are almost non-existent, so look to larger corporations that manage large quantities of data for positions. No matter which direction you go, take some SQL (not server) classes first to get to know the language. It varies a little between programs, but it pretty consistent for the most part. Here are my top five database career recommendations and why:

0 CommentsContinue Reading →

Determine which named instance you’re connected to

Posted on 1/27/11 3:00 PM by Get Schooled in Instance, in Microsoft, in New Horizons Computer Learning Center, in @@SERVERNAME, in SQL, in SQL Server, in T-SQL, in Tips & Tricks

Programmatically determine which named instance you’re connected to (SQL Server 2000/2005)

0 CommentsContinue Reading →

Search by Topic

    Lists by Topic

    see all

    Knowledge Ninjas

    a web-based service that allows software application end users to access a subject matter expert in real-time via a chat interface to resolve questions or problems they encounter in their specific software.

     

    Subscribe