Agus Wijiyanto

Salah satu tool untuk membatu presentasi.  Sample : Zooming Mode up zooms in down zooms out enter or left mouse click activates drawing of the zoomed area escape cancels zooming mode Zooming is also possible using the mouse wheel. Drawing Mode up/down or Ctrl+Mousewheel increases/decreases the size of the drawing brush right or Mousewheel cycles through the available brush colors 0-9 select the brush colors Shift while drawing forces horizontal/vertical drawing Control while drawing drawing straight lines right mouse-drag draws arrow lines right mouse-drag with control key pressed draws straight lines escape quits drawing mode backspace removes the last line drawn delete removes the first line drawn E removes all drawn lines M toggles the marker on/off T toggles between solid and merged drawing Z select a rectangle to zoom in C clears the screen with the background color

SELECT TOP 100     execquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery     CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql     ORDER BY execquery.last_execution_time DESC source :  https://stackoverflow.com/questions/39322918/last-executed-queries-on-sql-azure-database-basic-tier

Just five: &lt; (<), &amp; (&), &gt; (>), &quot; ("), and &apos; ('). For normal text (not markup), there are no special characters except < and &: just make sure your XML Declaration refers to the correct encoding scheme for the language and/or writing system you want to use, and that your computer correctly stores the file using that encoding scheme. See the question on non-Latin characters for a longer explanation. Apart from the invisible ASCII control characters (the ones you can't type), all other characters are just normal text. Currency signs (€, £, $, ƒ, ₨, Ƀ, and others), all the punctuation (except < and &), and all other letters, signs, and symbols in any language or writing system are just text (assuming you have the correct character encoding). If your keyboard will not allow you to type the characters you want, or if you want to use characters outside the limits of the encoding scheme you have chosen, you can...

This will open the new query wit connection to master database.  Note that you have to open the SQL editor with master database ! Then type following in the query in the editor:  CREATE LOGIN  yourusername  WITH password=’ YourPwd123 ‘; This will create the new LOGIN in the master database. Now execute following statement in the same editor: CREATE USER  yourusername  FROM LOGIN  yourusername  ; This statement will create the user from specified login in the  master  database. After that we need the to select wanted database (as in previous step, but this time you will not select  master  database) and open the query window. In that window enter same script as in previous step: CREATE USER  yourusername  FROM LOGIN  yourusername  ; This statement will create the user from specified login in your database. For example if you want to add it in the role of owners do following:  EXEC sp_addrole...

Slice your data queries in half Demystify complex relationships with SQL Server 2017 and graph source :  msft.it

I got a column called DateOfBirth in my csv file with Excel Date Serial Number Date Example: 36464 37104 35412 When i formatted cells in excel these are converted as 36464 => 1 / 11 / 1999 37104 => 1 / 08 / 2001 35412 => 13 / 12 / 1996 In SQL: SELECT DATEADD ( d , 36464 , '1899-12-30' ) -- or thanks to rcdmk SELECT CAST ( 36464 - 2 as SmallDateTime ) SELECT CONVERT (DATE, DATEADD(day, CONVERT(INT, 36464), '1899-12-30')) In SSIS, see here:  http://msdn.microsoft.com/en-us/library/ms141719.aspx Source :  https://stackoverflow.com/questions/13850605/convert-excel-date-serial-number-to-regular-date

Issue SQL Queries taking longer than normal to complete. Product Struxureware Power Monitoring Power Monitoring Expert ION Enterprise ION EEM Environment SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016 Cause When a database is frequently updated via INSERT, UPDATE, or DELETE statements we can expect it to become fragmented over the time. If database indexes are fragmented, the SQL Server query optimizer may chose a non-optimal execution plan when using an index to resolve a query. This will affect the overall query performance and you may notice a query behaving slower than normal. Resolution *Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.* The following is a simple query that will list every index on every table in your database, ordered by percentage of index fragme...