sqlserver*****.wordpress.com
SQL Server-ing you | A blog about SQL ServerA blog about SQL Server (by Nicolas de Fontenay)
http://sqlserverwhore.wordpress.com/
A blog about SQL Server (by Nicolas de Fontenay)
http://sqlserverwhore.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Thursday
LOAD TIME
0.5 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
5
SSL
EXTERNAL LINKS
0
SITE IP
192.0.78.12
LOAD TIME
0.547 sec
SCORE
6.2
SQL Server-ing you | A blog about SQL Server | sqlserverwhore.wordpress.com Reviews
https://sqlserverwhore.wordpress.com
A blog about SQL Server (by Nicolas de Fontenay)
sqlserverwhore.wordpress.com
SSIS – variables takes initial value before using expressions? | SQL Server-ing you
https://sqlserverwhore.wordpress.com/2009/07/20/ssis-variables-takes-initial-value-before-using-expressions
A blog about SQL Server. SSIS – variables takes initial value before using expressions? Leave a comment ». Wait a second… Could it… Is it…. Of course when something like that occur, you check your sources. The way things works, I got a date variable which is defined when calling dtexec with the day to be loaded (say 2009/07/19). Then this date is used to set the path for the files to be loaded: D: Load 20090719. Written by Nicolas de Fontenay. 2009/07/20 at 2:19 am. A send-mail function for powershell.
a send-mail function for powershell | SQL Server-ing you
https://sqlserverwhore.wordpress.com/2009/09/01/a-send-mail-function-for-powershell
A blog about SQL Server. A send-mail function for powershell. Leave a comment ». I’ve been working a lot with powershell. Our data warehouse processes are going to be controlled by powershell which in return calls SSIS procedures. Every steps are logged for success or failure. Everything is tracked. At powershell level however I needed to be informed if there’s a string malformation when dtexec is called for exemple. SmtpClient = new-object system.net.mail.smtpClient. Mailmessage.from = ($from). You are ...
SSIS – How to get the last date of a month? | SQL Server-ing you
https://sqlserverwhore.wordpress.com/2009/10/29/ssis-how-to-get-the-last-date-of-a-month
A blog about SQL Server. SSIS – How to get the last date of a month? Leave a comment ». I need to get the first and last date of a month in SSIS. These will be used to process partitions in my SSAS Cube afterwards. The riddle answer is: The last day of the month is the day before the first day of next month. 1) Create 3 variables: Date, MonthBeginning and MonthEnding. 2) Change MonthBeginning property “evaluate as expression to true” and edit the expression as follow. To summarize: we get the first day o...
T_SQL – Stored Procedure to create a time dimension | SQL Server-ing you
https://sqlserverwhore.wordpress.com/2009/09/04/t_sql-stored-procedure-to-create-a-time-dimension
A blog about SQL Server. T SQL – Stored Procedure to create a time dimension. Leave a comment ». This is a stored procedure that will build a 24 hour time dimension with it’s boundaries. Note: you should create the final table and plan for a surrogate key with identity(1,1). Also, to store hours in a 24h style, it’s not possible to use an int data type as this would wipe out the starting 0 (zero). Anyway. here goes:. ALTER PROCEDURE Sp Create Dim Time. SET @COUNT = 1. CREATE TABLE Dim Time TEMP. The resu...
SSIS and file reading using parallelism | SQL Server-ing you
https://sqlserverwhore.wordpress.com/2009/10/05/ssis-and-file-reading-using-parallelism
A blog about SQL Server. SSIS and file reading using parallelism. Leave a comment ». In this post, I’m discussing the usage of parallelism in SSIS when reading multiple flat files of different type located in the same folder. So what we have is an SSIS control flow with 5 different data flow components. Each data flow components perform a very simple task using a multiflatfile connection as a source and a database as a destinationeach feeding a different table. Type1, Type2, Type3,Type4 and Type5. Since ...
TOTAL PAGES IN THIS WEBSITE
5
SQL Server och Business Intelligence Utbildningar/Kurser | SolidQ
SQL Server and Business Intelligence. Tel 08 - 4060250. Tel 040 - 6160250. Email: se info (at) solidq.com.
SQL Server Utilities | Tools for DBA
A utility that automates the process of schema generation allowing you to keep database schema history at points in time. Very usefull and practical in variouse scenarios. Restores SQL Server backup files in order to verify that the backup files can be sucessfully restored and in addition perform data integrity checks on the backups restored while offloading the intensive IO activity from your production servers. 2014 All right resereved. SQL Server Utilities.
SQLServerVideos - Free Videos to Learn Microsoft SQL Server
Free SQL Server Video Tutorials and Training. Over 4.5 hours of free SQL Server Videos and Tutorials - no strings attached. Browse videos by series. Search for videos by keywords, terms, and topics. SQL Server Backups Demystified. Learn why SQL Server Backups can be hard to understand and master. A must-see video for anyone who isnt familiar with SQL Server Backup functionality. Backups, Recovery, Log Files, Transactions, and the SQL Server Storage Engine. Using SQL Server Templates. Follow SSV on Twitter.
דומיין|דומיינים|איחסון אתרים|אחסון אתרים|רישום דומיין|רישום דומיינים|איחסון
רכישת דומיין רישום דומיין קניית דומיין. מתעניין בחבילות אחסון נוספות? Win Basic אחסון אתרים. Win Premium אחסון אתרים. Win Pro אחסון אתרים. Win Lite אחסון אתרים. Win Ultimate אחסון אתרים. Win Reseller אחסון אתרים. Win SQL Server חבילות. Linux Super אחסון אתרים. Linux Advance אחסון אתרים. Linux Deluxe אחסון אתרים. VPS - שרתים ו. IBM X3250 שרת ייעודי. IBM X3550 שרת ייעודי. 160;אנו מאחסנים עשרות אלפי אתרים. 160;האחסון שלנו מתאים לוורדפרס. 160;האחסון שלנו מתאים ל joomla. 160;איננו גובים דמי התקנה!
SQL Server-ing you | A blog about SQL Server
A blog about SQL Server. SSIS – How to get the last date of a month? Leave a comment ». I need to get the first and last date of a month in SSIS. These will be used to process partitions in my SSAS Cube afterwards. The riddle answer is: The last day of the month is the day before the first day of next month. 1) Create 3 variables: Date, MonthBeginning and MonthEnding. 2) Change MonthBeginning property “evaluate as expression to true” and edit the expression as follow. To summarize: we get the first day o...
Home Page - My ASP.NET Application
THE ASP.NET is a free web framework for building great Web sites and Web applications using HTML, CSS and JavaScript. Learn more ». ASPNET MVC gives you a powerful, patterns-based way to build dynamic websites that enables a clean separation of concerns and gives you full control over markup for enjoyable, agile development. Learn more ». NuGet is a free Visual Studio extension that makes it easy to add, remove, and update libraries and tools in Visual Studio projects. Learn more ». Learn more ».
SQL Server Ya
Un curso de: Tutoriales Ya. SQL Server Ya desde CERO. El tutorial está pensado para que pueda ser desarrollado por una persona que conoce muy poco de programación. El objetivo de este sitio es poder aprender Microsoft SQL Server en forma sencilla viendo un concepto teórico, luego algunos ejercicios resueltos y por último y lo más importante efectuar una serie de ejercicios. Puede desarrollar los ejercicios en el sitio, probarlos y ver los resultados. Tipos de datos básicos. Valores null (is null).
SqlServerZest.com | SQL in simple style
SQL in simple style. SQL Server New Database Backup Encryption with SQL Server 2014. July 21, 2015 by Hareesh Gottipati. With the release of Microsoft SQL Server 2014. We have the first version of SQL Server that supports encrypting database backups directly from the database engine without any third party software being installed on the SQL Server. Preparing the Instance for Encrypted Backups. CREATE MASTER KEY ENCRYPTION BY PASSWORD=’MyPa$ w0rd’. If using a certificate, the certificate must be backed u...
