Agus Wijiyanto

Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual experience color theme options) really got me excited. To do this you have to edit system files, don’t get me wrong, it obviously is not a supported means to get the dark theme but I was curious to experience it. Here are the steps for SSMS 17. Navigate to C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\ Look for ssms PKGUNDEF File (Like the below) Search for // Remove Dark theme header and what you need to do is comment the whole block out with // SAVE FILE Restart SQL Server Management Studio and head to Tools > Options to  select the dark theme . This is what you will get. It does look like a work in progress. The connection and results pane seems to still be white but I still like it! Note: If the above does not work you may need to open notepad (Run as Admin) then navigate to the PKGUND...

Applies to ApexSQL Complete Summary This article describes how to set a custom connection color to a query tab in Microsoft  SQL Server Management Studio  (SSMS) using a feature called  Tab coloring  in ApexSQL Complete. Description Tab coloring can set custom connection colors for individual instances of SQL Server, down to the database level. The user has ability to assign SQL servers, and databases to a specific environment to help quickly identify which connection a tab is currently using.

Automatically complete SQL statements Review an object's script and description Improve productivity with snippets Identify the structure of complex SQL queries Keep track of all your tabs Log every executed query Easily navigate to SQL objects Check queries in test mode Color query tabs by environment Search and export query results Create CRUD procedures Guard against queries that may damage data source :  https://www.apexsql.com/sql_tools_complete.aspx

Table System Information She Sql Server SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE SPECIFIC_SCHEMA = N'dbo' AND SPECIFIC_NAME = N'getCustomer'

SELECT        hdr_callback, REPLACE(hdr_callback, 'https', 'http') FROM System.[Form.Headers] WHERE hdr_callback LIKE '%https%' UPDATE a   SET       a.hdr_callback = REPLACE(hdr_callback, 'https', 'http') FROM System.[Form.Headers] a WHERE       hdr_callback LIKE '%https%' SELECT        a.col_controlexpr, REPLACE(col_controlexpr, 'https', 'http') FROM System.[Form.Details] a WHERE col_controlexpr LIKE '%https%' UPDATE a   SET       a.col_controlexpr = REPLACE(col_controlexpr, 'https', 'http') FROM System.[Form.Details] a WHERE       col_controlexpr LIKE '%https%'

Panduan singkat install OpenWrt Totolink N300RT Download FrmUpg :  http://www.anphat.vn/download/FirmwareUpgradeTool.zip Putty : http://www.putty.org/ Frimware totolink v2.1.6 :  http://www.totolink.net/include/download.asp?path=down/010300&file=N300RT-V2.1.6_20160516.zip Bootloder boot96E_32M:  https://drive.google.com/open?id=1p0SreEifzElS_cyngZZRL2lmGnR-Mvvi OpenWrt  :  https://drive.google.com/open?id=1ykv6QkrqXJ_8vnX-6imib44XGFVNJZoA A. Downgrade Frimware Totolink ke v2.1.6 Dalam router dalam keadaan mati tekan Tombol Reset lalu hidupkan power. tunggu sampai lampu indikator lan berkedip. Matikan Firewall dan Buka FrmUpg.exe dan colokan LAN ke Port 1,2,3,4 Di Frimware File pilih file Totolink v2.1.6 dan klik send, Tunggu sampai prosess selesai lalu restart router, cek 192.168.1.1 apakah sudah berhasil downgrade. B. Upgrade OpenWrt Ulangi langkah no 1, Pilih file bootloder boot96E_32M. klik send. tunggu sampai selesa...

How can I get all the table names where the given column name exists? I want the names with "Like" in sql server. SELECT c.name AS ColName ,t.name AS TableName FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE '%MyCol%';